This documentation is archived and is not being maintained.

Visual Basic: RDO Data Control

Visual Studio 6.0

MoreResults Method (Remote Data)

See Also    Example    Applies To

Clears the current result set of any pending rows and returns a Boolean value that indicates if one or more additional result sets are pending.

Syntax

variable = object.MoreResults

The MoreResults method syntax has these parts:

Part Description
variable A Boolean variable that indicates if additional result sets are found as described in Return Values.
object An object expression that evaluates to an open rdoResultset object variable.

Return Values

The return values for variable are:

Value Description
True Additional result sets are ready to be processed.
False All result sets in the rdoResultset have been processed.

Remarks

Calling this method will flush the current result set, call the ODBC API SQLMoreResults function to see if there is another result set on the same statement, and if there is, loads the new result set, positions the current row pointer at the first row and returns True. If there are no more result sets, this method will return False, and both the EOF and BOF properties will be True.

If the result set was created asynchronously (developer used rdAsyncEnable in the Options parameter), the MoreResults method will be executed asynchronously as well. You should use the StillExecuting property to determine when the next result set has been enabled. Asynchronous execution of the MoreResults method follows the same rules as asynchronously opening a result set.

When the query used to create an rdoResultset returns more than one result set, use the MoreResults method to end processing of the current result set and test for subsequent result sets. If there are no additional result sets to process, the MoreResults method returns False and both BOF and EOF are set to True. In any case, using the MoreResults method flushes the current rdoResultset.

You can also use the Cancel method to flush the contents of an rdoResultset. However, Cancel also flushes any additional result sets not yet processed.

Not all cursor libraries support multiple resultset queries. For example, the Server-side cursor library does not support this type of query unless you disable the cursor processor by requesting a forward-only, read-only cursor with a RowsetSize property of 1.

Show: