Xojo Documentation Xojo Documentation

Method

RecordSet.MovePrevious()

Supported for all project types and targets.

Moves the record pointer to the previous record in the RecordSet.

Notes

Currently only supported by these databases:

• SQLiteDatabase
• OracleDatabase
• ODBCDatabase, although not all ODBC drivers implement this

A RecordSet is populated in memory when you call the SQLSelect method. If you use MovePrevious to go back to prior records (including those that you may have changed using the Edit method), then you will get the values that were originally populated, not the changed values.

Example

This example moves the record pointer to the previous record in the RecordSet.

// move to the previous record/row
rs.MovePrevious