ADO » Recordset » MoveNext
- Syntax:
- recordsetobject.MoveNext
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.
Examples
Code:
rsGuruChants.MoveFirst
Do While Not rsGuruChants.EOF
If rsGuruChants.Status = adRecModified Then
Response.Write rsChants("ChantTitle") & VBCRLF
End If
rsGuruChants.MoveNext
Loop
Code:
Sub MoveFirst_OnClick
objDataControl.objRecordset.MoveFirst
End Sub
Sub MoveLast_OnClick
objDataControl.objRecordset.MoveLast
End Sub
Sub MoveNext_OnClick
If objRecordset.EOF = False Then
objDataControl.objRecordset.MoveNext
End If
End Sub
Sub MovePrevious_OnClick
If objRecordset.BOF = False Then
objDataControl.objRecordset.MovePrevious
End If
End Sub
Explanation:
RDS allows the Recordset object to be bound to an HTML tag so that the data can be displayed on a web page. You can use four buttons on a Web page to navigate through a displayed recordset. When a button is clicked, a subroutine containing one of the four move methods is called.
See Also:
