Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Programming » SQL Anywhere Data Access APIs » SQL Anywhere C API reference » sacapi.h

 

sqlany_get_next_result function

Advances to the next result set in a multiple result set query.

Syntax
sacapi_bool sqlany_get_next_result( a_sqlany_stmt * stmt )
Parameters
  • stmt   A statement object executed by sqlany_execute or sqlany_execute_direct.

Returns

1 if the statement successfully advances to the next result set, 0 otherwise.

See also
Example
  stmt = sqlany_execute_direct( conn, "call my_multiple_results_procedure()" );
   if( result ) {
       do {
           while( sqlany_fetch_next( stmt ) ) {
               // get column data
           }
       } while( sqlany_get_next_result( stmt ) );
       sqlany_free_stmt( stmt );
   }