recordset.moreresults

Description

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.

Example

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.

Portability

Operating Systems: All
Standard Pascal: No