VFP ODBC driver doesn't support any new data features introduced in VFP7 and later. You can use VFP OLE DB provider if you want to access VFP tables with such features.

>My application is using an ODBC connection to connect to a VFP table and when I execute the SQLEXEC() command on any table that contains a field that is set as autoincrement nothig gets returned. when I do the same thing
>on the same table that exists in a SQL server database it works fine, if I take the autoincrement off the field in the vfp table it works fine.
>
>Does anyone know of a workaround for this ?
>