ADO NextRecordset Method
 Complete Recordset Object Reference
The NextRecordset method is used to clear the current Recordset object and
return the next Recordset object by looping through a series of commands. This
method returns a Recordset object.
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
Recordset, will only execute the first command and return the result to a
Recordset object. To access the result of the next command in the statement, call the NextRecordset method.
If a row-returning command executes successfully but returns no records, the returned Recordset object will be open but
empty (BOF and EOF are both True). If a non–row-returning command executes successfully, the returned Recordset object will be
closed (State property is adStateClosed). When there are no more results, the
Recordset object will be set to Nothing.
Syntax
|
Set objRecordset2=objRecordset1.NextRecordset(ra)
|
Note: objRecordset1 and objRecordset2 can be the same Recordset object.
| Parameter |
Description |
| ra |
Optional. Returns the number of records affected by
the operation
|
Complete Recordset Object Reference
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
