ADODB Object
 
Syntax
 
recordsetobject.MoveNext
 
Description
Moves the position of the current record pointer forward to the next record.
 
The MoveNext method is called to move to the next record in the specified Recordset object.
 
If you are at the last record, calling this method will put you at EOF and the EOF property will be set to True. If you are at EOF and call this method, an error will be generated.
 
This is one of four methods belonging to the Recordset object that allow you to navigate or move through a data record. The other three are, MoveFirst, MoveLast, and MovePrevious.
See Also
Example
 
rsGuruChants.MoveFirst
Do While Not rsGuruChants.EOF
   If rsGuruChants.Status = adRecModified Then
      Response.Write rsChants("ChantTitle") & VBCRLF
   End If
   rsGuruChants.MoveNext
Loop