Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Troubleshooting on SQLExec connectivity
Message
De
20/06/2006 09:10:47
 
 
À
19/06/2006 18:48:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01130093
Message ID:
01130222
Vues:
15
Hi Michel.

>Ok, the ODBC driver doesn't work with auto incremental fields. What are my options to use a SQLExec() approach if I have auto incremental fields? Or, do I have to use Cursor Adapater to achieve something similar?

You can't use the ODBC driver with any database or table that has features added after VFP 6, which was the last time the ODBC driver was updated. You'll have to use the VFP OLE DB provider instead. Yes, I'd suggest using CursorAdapters, because they make it relatively easy to convert between ADO Recordsets and VFP cursors.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform