ADO MoveFirst, MoveLast, MoveNext, and MovePrevious Methods
 Complete Recordset Object Reference
The MoveFirst Method
This method is used to move to the first record in a Recordset object. It
also make the first record the current record.
Note: Calling MoveFirst or MoveLast when the Recordset is empty generates an error.
The MoveLast Method
This method is used to move to the last record in a Recordset object. It also
make the last record the current record.
Note: Calling MoveFirst or MoveLast when the Recordset is empty generates an error.
Note: An error will occur if the Recordset object does not support bookmarks or backward cursor
movement.
The MoveNext Method
This method is used to move to the next record in a Recordset object. It also
make the "next" record the current record.
Note: If you call this method when the current record is the last
record, it generates an error.
The MovePrevious Method
This method is used to move to the previous record in a Recordset object. It
also make the "previous" record the current record.
Note: An error will occur if the Recordset object does not support bookmarks or backward cursor
movement.
Note: If you call this method when the current record is the first
record, it generates an error.
Syntax
objRecordset.MoveFirst
objRecordset.MoveLast
objRecordset.MoveNext
objRecordset.MovePrevious
|
Complete Recordset Object Reference
Whether you're new to XML or already an advanced user, the user-friendly views
and powerful entry helpers, wizards, and debuggers in XMLSpy are designed to
meet your XML and Web services development needs from start to finish.
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- Support for Office Open XML (OOXML)
- Graphical WSDL editor & SOAP debugger
- Java, C#, C++ code generation
- And much more!
Download a fully functional free 30-day trial today!
| 
