... is supported for SQL_SCROLL_FORWARD_ONLY cursors

... is supported for SQL_SCROLL_FORWARD_ONLY cursors

Post by Michael An » Tue, 14 Nov 2006 17:10:46


Hi,

A informix-ODBC-connection wrote the errormessage:

HY106:[INTERSOLV][ODBC Informix driver]In SQLExtendedFetch, only
SQL_FETCH_NEXT is supported for SQL_SCROLL_FORWARD_ONLY cursors.

who knows the ODBC command for setting the cursor limitations?

thanks michael
 
 
 

... is supported for SQL_SCROLL_FORWARD_ONLY cursors

Post by Chris Kush » Wed, 15 Nov 2006 16:15:10

Generally you use either:

SQLSetStmtAttr(hnd, SQL_ATTR_CONCURRENCY, ...);
SQLSetStmtAttrW(hnd, SQL_ATTR_CURSOR_TYPE, ...);

or,

SQLSetStmtAttr(hnd, SQL_ATTR_CURSOR_SENSITIVITY, ...);
SQLSetStmtAttrW(hnd, SQL_ATTR_CURSOR_SCROLLABLE, ...);


cmk