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() .