Skip to content
≡

Administrator

Developer

Tools

External Tools

SQLMoreResults

SQLMoreResults#

SQLMoreResults returns whether there is more result.

Syntax#

SQLRETURN SQLMoreResults (
    SQLHSTMT        stmt);

Argument#

Data Type Argument In/Output Description
SQLHSTMT stmt Input Instruction handle

Result Values#

SQL_SUCCESS
SQL_NO_DATA

Description#

When a statement is fetched to obtain its result, the corresponding cursor is located at the first record of the result set. Depending on an application, when its result set is used, a further check is performed to see if there is more result left. If there are more result values left, SQL_SUCCESS is returned, and if not, SQL_NO_DATA_FOUND is returned.

If the result set is fetched, the cursor is located at the first result set. Depending on an application, when its result set is used, a further check is performed to see if there is more result left. If there are more result values left, SQL_SUCCESS is returned, and if not, SQL_NO_DATA_FOUND is returned.

SQLFetch