Its probably the SQLTABLES command itself..



>>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