Executing Cancel in Open SQL
Method RWDBOSql::cancel() can be used either to cancel the current result set or to cancel all pending result sets of the current execution. This method should be called only after the RWDBOSql object is executed.
Method RWDBOSql::cancel(RWDBOSql::Current) cancels the current result set and moves the RWDBOSql to the next available result set, if any.
Method RWDBOSql::cancel(RWDBOSql::All) cancels all the pending result sets. No subsequent results will be available from the current execution after this call has been made.