SQLFetch()--Fetch Single Rows
SQLFetch() fetches a single row of data after a select query has been executed. As with all ODBC functions, SQLFetch() returns a status that can be analyzed to determine whether the end of the result set has been reached.
The following example shows how SQLFetch() is used:
RETCODE rc = SQL_SUCCESS;
SQLExecDirect( hstmt, "select models from cars", SQL_NTS );
while ( TRUE )
{
rc = SQLFetch( hstmt );
if (rc == SQL_NO_DATA_FOUND)
{
printf("End of data.\n" );
break;
}
if ( !SQL_SUCCEEDED( rc ) )
{
printf("Error! status is %d\n", rc );
break;
}
}