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

Syntax

sacapi_bool sqlany_get_next_result( a_sqlany_stmt * stmt )

Parameters

Returns

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

See also

• sqlany_execute function
• sqlany_execute_direct function

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 );
   }