NextRecordset - method of the AdoRecordset object
Description:
Use this method to return the results of the next command in a compound command statement or the next result of a stored procedure that returns multiple results.
For example, in a compound command statement, like
"SELECT * FROM table1;SELECT * FROM table2", the
Execute method on a
Command or the
AdoRecordset.Open method, will only execute the first command and return the result into the
AdoRecordset object.
To access the result of the next command in the statement, call the
NextRecordset method.
Syntax:
Object NextRecordset([Long RecordsAffected])
Parameters:
| RecordsAffected | [optional] (Long) Returns the number of records affected by the operation. |
|---|
Example:
JavaScriptVBScriptSelect and copy to clipboard
var oRs2 = oRs.NextRecordset(ra);
Dim oRs2
Set oRs2 = oRs.NextRecordset(ra)