ODBC_SQLFetchScroll

4D v16

ODBC_SQLFetchScroll


ODBC_SQLFetchScroll ( stmtID ; fetchOrientation ; fetchOffset ) -> Resultado

Parâmetro	Tipo	Descrição
stmtID	Inteiro longo	Statement ID
fetchOrientation	Inteiro longo	Type of fetch
fetchOffset	Inteiro longo	Number of the row to fetch
Resultado	Inteiro longo	Returns the result of the MS ODBC API function SQLFetchScroll

Descrição

The ODBC_SQLFetchScroll command fetches the specified rowset of data from the result set and returns data for all bound columns. Rowsets can be specified at an absolute or relative position or by bookmark.

stmtID is a valid statement ID returned by ODBC_SQLAllocStmt.

fetchOrientation is the type of fetch and can be one of the following types:

Constant	Description
SQL_FETCH_NEXT	Return the next rowset
SQL_FETCH_PRIOR	Return the prior rowset
SQL_FETCH_FIRST	Return the first rowset
SQL_FETCH_LAST	Return the last rowset
SQL_FETCH_ABSOLUTE	Return the rowset starting at row fetchOffset.
SQL_FETCH_RELATIVE	Return the rowset fetchOffset from the start of the current rowset
SQL_FETCH_BOOKMARK	Return the rowset fetchOffset rows from the bookmark

fetchOffset is the offset to be used when the contant SQL_FETCH_ABSOLUTE or SQL_FETCH_RELATIVE is passed to the fetchOrientation argument

For more information, please see the SQLFetchScroll function in the MS ODBC API Reference at http://msdn.microsoft.com/en-us/library/ms714682(VS.85).aspx.

Function Results

SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.

Ver também

ODBC_SQLBindCol
ODBC_SQLFetch