The moreresults method procedure of the recordset object type is used to to move to the next recordset contained by an open recordset. NOTE: This method should not to be confused with the movenext method which moves to the next record in the current recordset. This method is most often used when calling stored procedures that return multiple recordsets.
For example if you open a recordset like so
rs.open(conn, 'EXEC procName')
and the stored procedure procName returns multiple recordsets then the recordset object will be positioned at the first record of the first recordset. The call
rs.movenext;
would move to the second record in the first recordset, but the call
rs.moreresults
would move to the first record in the second recordset.
Operating Systems: All
Standard Pascal: No