Hi John,
Using VFP 5.0 with the 3.6 ODBC driver for MS SQL Server gives the new column names also.
-Mike
>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