Full text search
function	SQLFetchScroll

Library: ODBC Include: omodbc.xin

Returns: Numeric An SQL return code. The following values may be returned: SQL_SUCCESS (data was returned for all bound columns). SQL_SUCCESS_WITH_INFO (data was returned for all bound columns, but a message was issued). SQL_ERROR (an error occurred). SQL_INVALID_HANDLE (the handle is invalid). SQL_NO_DATA (no data was found). SQL_STILL_EXECUTING (the program is still executing).

Declaration

  define external counter function SQLFetchScroll
     (  read-only sql_handle_type StatementHandle,
        value counter FetchOrientation,
        value counter FetchOffset )

Fetches the specified row set of data from the result set and returns data for all bound columns. Row sets can be specified at an absolute or relative position, or by bookmark.

Input arguments:

1. StatementHandle.
2. FetchOrientation. The following values are allowed:
   • SQL_FETCH_NEXT
   • SQL_FETCH_FIRST
   • SQL_FETCH_LAST
   • SQL_FETCH_PRIOR
   • SQL_FETCH_ABSOLUTE
   • SQL_FETCH_RELATIVE
   • SQL_FETCH_BOOKMARK
3. FetchOffset. The number of the row to fetch. The interpretation of this argument depends on the value of the FetchOrientation argument.