4D v13
ODBC_SQLFetchScroll
- 4D ODBC Pro
-
- ODBC_Results
-
- Retrieving Results and Information, Introduction
- ODBC_SQLBindCol
- ODBC_SQLBulkOperations
- ODBC_SQLColAttribute
- ODBC_SQLDescribeCol
- ODBC_SQLFetch
- ODBC_SQLFetchScroll
- ODBC_SQLGetData
- ODBC_SQLGetDescField
- ODBC_SQLGetDescRec
- ODBC_SQLGetDiagField
- ODBC_SQLGetDiagRec
- ODBC_SQLMoreResults
- ODBC_SQLNumResultCols
- ODBC_SQLRowCount
- ODBC_SQLSetDescField
- ODBC_SQLSetDescRec
- ODBC_SQLSetPos
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 | |||||
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.
SQL_SUCCESS, SQL_SUCCESS_WITH_INFO, SQL_NO_DATA, SQL_STILL_EXECUTING, SQL_ERROR, or SQL_INVALID_HANDLE.
Product: 4D
Theme: ODBC_Results
Number:
16959
Created: 4D ODBC Pro 2004
