Version: 7.0.0

SQLFetch ​

Function ​

Fetches the next rowset of data from a result set and returns the data of all bound columns.

Prototype ​

c
SQLRETURN SQLFetch(SQLHSTMT    StatementHandle);

Parameters ​

Table 1 SQLFetch parameters

Keyword

Parameter Description

StatementHandle

Statement handle, obtained through SQLAllocHandle.

Return Values ​

  • SQL_SUCCESS: The call is successful.

  • SQL_SUCCESS_WITH_INFO: Some warning information is present.

  • SQL_ERROR: Row data failed to be fetched from the result set.

  • SQL_NO_DATA: The SQL statement does not return a result set.

  • SQL_INVALID_HANDLE: The input handle is invalid.

Example ​

See: Example