| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | apitype | |
|---|---|---|---|---|---|---|---|---|---|---|
SQLFetchScroll |
SQLFetchScroll |
markingmyname |
maghan |
03/17/2017 |
sql |
native-client |
reference |
|
DLLExport |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
SQLFetchScroll returns one row set of data to the application. The size of the row set is set using SQLSetStmtAttr. The [!INCLUDEssNoVersion] Native Client 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.
Result column values of date/time types are converted as described in Conversions from SQL to C.
For more information, see Date and Time Improvements (ODBC).
SQLFetchScroll supports large CLR user-defined types (UDTs). For more information, see Large CLR User-Defined Types (ODBC).