Skip to content

SqlFetchOrientation

[Source]

SqlFetchOrientation

SqlFetchOrientation Meaning
SqlFetchNext Return the next rowset. This is equivalent to calling SQLFetch.

SQLFetchScroll ignores the value of FetchOffset.
SqlFetchPrior Return the prior rowset.

SQLFetchScroll ignores the value of FetchOffset.
SqlFetchRelative Return the rowset FetchOffset from the start of the current rowset.
SqlFetchAbsolute Return the rowset starting at row FetchOffset.
SqlFetchFirst Return the first rowset in the result set.

SQLFetchScroll ignores the value of FetchOffset.
SqlFetchLast Return the last complete rowset in the result set.

SQLFetchScroll ignores the value of FetchOffset.
SqlFetchBookmark Return the rowset FetchOffset rows from the bookmark specified by the SQL_ATTR_FETCH_BOOKMARK_PTR statement attribute. 
type SqlFetchOrientation is
  (SqlFetchNext val | SqlFetchFirst val | SqlFetchLast val | SqlFetchPrior val | SqlFetchAbsolute val | SqlFetchRelative val | SqlFetchBookmark val)

Type Alias For