ODBC_SQLFetchScroll

Home

4D v16

ODBC_SQLFetchScroll


ODBC_SQLFetchScroll ( stmtID ; fetchOrientation ; fetchOffset ) -> Funktionsergebnis

Parameter	Typ	Beschreibung
stmtID	Lange Ganzzahl	Statement ID
fetchOrientation	Lange Ganzzahl	Type of fetch
fetchOffset	Lange Ganzzahl	Number of the row to fetch
Funktionsergebnis	Lange Ganzzahl	Returns the result of the MS ODBC API function SQLFetchScroll

Beschreibung

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.

Siehe auch

ODBC_SQLBindCol
ODBC_SQLFetch