David's Weblog

Today, I ran into an old nemesis, the evil and practically impossible problem to troubleshoot:

Error: GetFieldValue operation failed on field 1.
Invalid Descriptor Index
State:S1002,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0]

All the code was doing:

CString strSQLSelectStatement;
strSQLSelectStatement.Format(“SELECT column2, column1 FROM myTable”);

setGetMyRecords.Open(CRecordset::forwardOnly,LPCTSTR(strSQLSelectStatement));
 
CDBVariant dbvColumn1;

setGetMyRecords.GetFieldValue(“column1_dbf”, dbvColumn1);

int nColumn1 = 0;

if (dbvColumn1.m_dwType != DBVT_NULL)
{
     nColumn1 = dbvColumn1.m_lVal;
}

CString strColumn2;

setGetMyRecords.GetFieldValue(“column2_dbf”, strColumn2);

The exception occurred when the 2nd call to GetFieldValue() happened. The error hardly helps explain the problem or its cause.

The problem is with the way ODBC wraps the data in the record set. You must change your SELECT statement to select the integers before the strings.