Retrieval Procedures
This topic discusses the retrieval procedures in alphabetical order.
Syntax
RETCODE SQLFetch(hstmt)
Description
SQLFetch fetches a row of data from a result set. The driver returns data for all columns that were bound to storage locations with SQLBindCol. SQLFetch positions the cursor on the next row of the result set. When the cursor is positioned to the last row of the result set, SQLFetch returns SQL_NO_DATA_FOUND.
If the application called SQLBindCol to bind columns, SQLFetch stores data in the locations specified by the calls to SQLBindCol. If the application does not call SQLBindCol to bind any columns, SQLFetch does not return any data; it just moves the cursor to the next row. An application can call SQLGetData to retrieve data not previously bound to a storage location.
Parameters
This table describes the parameter:
Argument |
Type |
Use |
Description |
---|---|---|---|
hstmt |
HSTMT |
Input |
Statement handle. |
Syntax
RETCODE SQLGetData(hstmt,icol,fCType,rbgValue,cbValueMax,pcbValue)
Description
SQLGetData returns result data for a single unbound column in the current row. The application must call SQLFetch to position the cursor on a row of data before it calls SQLGetData. You can use SQLBindCol for some columns and use SQLGetData for others within the same row. This function can be used to retrieve character or binary data values in parts from a column with a character, binary, or data-source-specific data type (for example, data from SQL_LONGVARBINARY or SQL_LONGVARCHAR columns).
Parameters
This table describes the parameters:
Argument |
Type |
Use |
Description |
---|---|---|---|
hstmt |
HSTMT |
Input |
Statement handle. |
icol |
UWORD |
Input |
Column number of result data. |
fCType |
SWORD |
Input |
The C data type of the result data. |
rbgValue |
PTR |
Both |
A pointer to storage for the result column. |
cbValueMax |
SDWORD |
Input |
Maximum length of the rgbValue buffer. |
pcbValue |
SDWORD FAR* |
Both |
A pointer to a buffer for the SQL_NULL_DATA or the number of bytes available to return in rgbValue prior to calling SQLFetch. |