Name

exec_next — Get next result from a result set

Synopsis

integer retcode exec_next ( in cursor_handle long ,
  out sql_state varchar ,
  out sql_error varchar ,
  out row_array vector );
 

Description

Use exec_next() to iterate over a result set produced by a statement run with exec .

open a cursor with exec .
loop over the results with exec_next
if exec_next does not return an error or SQL_NO_DATA_FOUND continue the loop with exec_next, otherwise
close the cursor with exec_close

Parameters

cursor_handle

The long cursor handle as obtained from exec().

row_array

An output vector that will contain the result columns.

sql_state

Optional varchar output parameter for SQL state.

sql_error

Optional varchar output parameter for any error message.

Return Values

All data is returned in output parameters.

See Also

exec() , exec_close() .