SQLFetchScroll

ODBC and SQL Server

ODBC and SQL Server

SQLFetchScroll

SQLFetchScroll returns one row set of data to the application. The size of the row set is set using SQLSetStmtAttr. The Microsoft® SQL Server™ ODBC driver supports all defined fetch instructions (for example, SQL_FETCH_RELATIVE) with the following limitations:

  • If a forward-only cursor is defined for the statement, SQL_FETCH_NEXT is required and attempts to fetch in any other fashion will result in an error return.

  • SQL_FETCH_BOOKMARK is supported for static and keyset-driven cursors only.