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:
00146730
Views:
25
>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?

Hi John,

I thought it might have something to do with ADO. If the ODBC driver for VFP 6.0 is new, then yes, I do have a new driver.

Do you think it is the driver or the function defining the cursor?

Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform