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

The Altova MissionKit is an integrated suite of tools ideal for:
- XML development
- Web & Web services development
- Data mapping & integration
- Rendering & publishing XML & database data
- XBRL validation, taxonomy editing, transformation & rendering
The MissionKit for XML Developers includes XMLSpy® - the industry-leading XML editor; MapForce® - a
graphical data mapping, conversion, and integration tool; StyleVision® - a visual XSLT stylesheet designer;
DiffDog® - an XML-aware diff/merge tool; and 2 additional tools.
Try all 6 products free for 30 days!
Download a fully-functional free trial
|
|
|
|