4D Doc Center : ODBC_SQLFetchScroll

Home

4D v14.1

ODBC_SQLFetchScroll


ODBC_SQLFetchScroll ( stmtID ; fetchOrientation ; fetchOffset ) -> Function result

Parameter	Type	Description
stmtID	Longint	Statement ID
fetchOrientation	Longint	Type of fetch
fetchOffset	Longint	Number of the row to fetch
Function result	Longint	Returns the result of the MS ODBC API function SQLFetchScroll

Description

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.