Gettting a SQLExtendedFetch Error?
Posted on 1999-07-31
I'm getting the following erro: S1106
[Sybase][ODBC Driver] An invalid fFetch Type value was specified.
in the SQLExtendedFetch() return value means:
S1106 Fetch type out of range The value specified for the argument fFetchType was not equal to:
Here is what my code is doing:
"SELECT empl_ssn FROM employee WHERE empl_company = '%s' AND \
empl_qtr = %ld AND empl_work_state = 'CT' OR empl_work_state = 'GU'",
"873500", 199901 );
m_DBase->createHandle( &hScroll );
m_DBase->sql( hScroll, sBuff );
m_DBase->bindString( hScroll, 1, sSSN, 10 );
m_DBase->fetchEx( hScroll, SQL_FETCH_FIRST, nRecordCount );
which is a thin wrapper class.
so createHandle is SQLAllocStmt()
sql is SQLExecDirect()
bindString just binds is SQLBindCol()
Here is the code for the fetchEx:
retCode = SQLExtendedFetch(hStmt, SQL_FETCH_FIRST, NULL, NULL, NULL);
Can any help explain what this error means and how it is caused and how to fix it.