Cancels any rows pending from the most recently executed query.
RETCODE dbcanquery ( PDBPROCESS dbproc );
SUCCEED or FAIL.
This function is an efficient way to throw away any unread rows that result from the most recently executed SQL query. Calling dbcanquery is similar to calling dbnextrow until it returns NO_MORE_ROWS. Binds are broken before rows are read.
The dbresults function must return SUCCEED before an application can call dbcanquery.
If you want to ignore all of the results from all of the commands in the current command batch, call dbcancel.
dbcancel | dbresults |
dbnextrow | dbsqlexec |