|
|
|
|
|
|
|
|
|
version 2004
ODBC_SQLFetchScroll (stmtID; fetchOrientation; fetchOffset) 
Longint
| 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 at http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlfetchscroll.asp.
Function Results
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
See Also
ODBC_SQLBindCol, ODBC_SQLFetch.
|
|
|
|
|
|
|
|
|