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
Open method on a
AdoRecordset, 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)