Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLTABLES returns different fields in 6.0 than in 5.0
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQLTABLES returns different fields in 6.0 than in 5.0
Miscellaneous
Thread ID:
00146638
Message ID:
00146638
Views:
64
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?
Next
Reply
Map
View

Click here to load this message in the networking platform