4D v13

ODBC_SQLFetchScroll

Home

 
4D v13
ODBC_SQLFetchScroll

ODBC_SQLFetchScroll 


 

ODBC_SQLFetchScroll ( stmtID ; fetchOrientation ; fetchOffset ) -> Function result 
Parameter Type   Description
stmtID  Longint in Statement ID
fetchOrientation  Longint in Type of fetch
fetchOffset  Longint in Number of the row to fetch
Function result  Longint in 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:

ConstantDescription
SQL_FETCH_NEXTReturn the next rowset
SQL_FETCH_PRIORReturn the prior rowset
SQL_FETCH_FIRSTReturn the first rowset
SQL_FETCH_LASTReturn the last rowset
SQL_FETCH_ABSOLUTEReturn the rowset starting at row fetchOffset.
SQL_FETCH_RELATIVEReturn the rowset fetchOffset from the start of the current rowset
SQL_FETCH_BOOKMARKReturn 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.

 
PROPERTIES 

Product: 4D
Theme: ODBC_Results
Number: 16959

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D ODBC Pro 2004

 
SEE ALSO 

ODBC_SQLBindCol
ODBC_SQLFetch