Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLTABLES returns different fields in 6.0 than in 5.0
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00146638
Message ID:
00146730
Vues:
26
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform