4D v16

ODBC_SQLFetchScroll

Página Inicial

 
4D v16
ODBC_SQLFetchScroll

ODBC_SQLFetchScroll 


 

ODBC_SQLFetchScroll ( stmtID ; fetchOrientation ; fetchOffset ) -> Resultado 
Parâmetro Tipo   Descrição
stmtID  Inteiro longo in Statement ID
fetchOrientation  Inteiro longo in Type of fetch
fetchOffset  Inteiro longo in Number of the row to fetch
Resultado  Inteiro longo 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.



Ver também 

ODBC_SQLBindCol
ODBC_SQLFetch

 
PROPRIEDADES 

Produto: 4D
Tema: ODBC_Results
Número 16959

 
HISTÓRIA 

Criado por: 4D ODBC Pro 2004

 
ARTICLE USAGE

4D ODBC Pro ( 4D v16)