Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLTABLES returns different fields in 6.0 than in 5.0
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00146638
Message ID:
00146696
Views:
29
This could be a result of getting compliant with with ADO. Also, did your SQL Server ODBC Driver change???

In any case, it should be documented.


>I am using SQLTABLES to return a list of tables in the SQL Server backend. In VFP 5, it works as the help file describes. In 6.0, the names of the fields in the cursor returned are:
>
>TABLE_CAT (Should be TABLE_QUALIFIER)
>TABLE_SCHEM (Should be TABLE_OWNER)
>TABLE_NAME Same
>TABLE_TYPE Same
>REMARKS Same
>
>I don't see any KB articles on it. Can anyone verify this? (or am I going crazy) Does anyone know why this changed?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform