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.