Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Troubleshooting on SQLExec connectivity
Message
From
20/06/2006 09:10:47
 
 
To
19/06/2006 18:48:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01130093
Message ID:
01130222
Views:
14
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform