Article ID: 269021
Article Last Modified on 8/27/2002
APPLIES TO
- Microsoft Visual FoxPro 5.0 Standard Edition
- Microsoft Visual FoxPro 5.0a
- Microsoft Visual FoxPro 6.0 Professional Edition
This article was previously published under Q269021
SYMPTOMS
The Microsoft Visual FoxPro View Designer displays fields incorrectly when the view is based on tables from a Synergy/DE version 7.1 Driver.
RESOLUTION
In most cases the following workaround can be used:
Create the view programmatically by using code similar to the following:
CREATE SQL VIEW "FYF002" ; REMOTE CONNECT "Synergex" ; AS SELECT * FROM customers
NOTE: The view can then be manipulated visually as long as the tables from Synergy/DE 7.1 have been added programmatically prior to editing the view visually.
MORE INFORMATION
Steps to Reproduce Behavior
NOTE: The following assumes that you have Synergy/DE 7.1 installed on the test system.
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
- Create a new database called TestODBC.
- Create a new remote view, and then select the Synergy Driver Stand-alone from available Data Source Names (DSN).
- In the dialog box that appears, enter your user id and password provided by Synergex Corporation.
- Add the Public.customers table to the view.
Note the fields in the Customer cursor in the tables area of the view designer. The fields listed are not those in the actual table, but appear to be system information (t_database, t_owner, and so forth). The expected fields are: Customer_id, Cust_rtype, Customer_name, Customer_street, and so forth.
NOTE: This behavior does not occur in Visual Basic or Microsoft Query.
REFERENCES
(c) Microsoft Corporation 2000, All Rights Reserved. Contributions by Kenneth Robison, Microsoft Corporation.
Keywords: kbcodesnippet kbdatabase kbprb kbbuilder KB269021