When I access my Access database using ODBC and getfieldvalue in forward field index order or backward index order I have no problems.
When I try to access the same database converted to MSSQL using a variety of converters and simply point at the new ODBC connection, DBCORE.CPP throws an error "GetFieldValue operation failed on field" if I try to fietch a field using an index less than the last field fetched.
My code (simplified) is :
rs.Open(CRecordset::dynaset,"SELECT * from DATAB");
rs->GetFieldValue(4,cstrg); \\ Fails
Is this a limitation of the MSSQL ODBC driver ?
To fetch in any other order is a real problems.
Any ideas ??