SQLExtendedFetch
Full Description
swirl
Syntax
  define external counter function SQLExtendedFetch
     (  read-only SQL_handle_type StatementHandle,
        value counter FetchOrientation,
        value counter FetchOffset,
        modifiable counter RowCount,
        read-only SQL_vector_type RowStatusArray )


Purpose

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. This function has been superseded by SQLFetchScroll in ODBC 3.0.

Input arguments:

  1. StatementHandle.
  2. FetchOrientation. The type of fetch. 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 rows to fetch.
  4. RowStatusArray. The status of each row.

Output argument:

  • RowCount. The number of rows actually fetched.

Copyright © OmniMark Technologies Corporation, 1988-1998.