RowSet.MoveToPreviousRow
From Xojo Documentation
Method
Moves the current row to the previous row in the RowSet.
Notes
Currently only supported by these databases:
- SQLiteDatabase
- OracleDatabase
- ODBCDatabase, although not all ODBC drivers implement this
A RowSet is populated in memory when you call the SelectSQL method. If you use MoveToPreviousRow to go back to prior rows (including those that you may have changed using the EditRow method), then you will get the values that were originally populated, not the changed values.
Example
This example moves the current row to the previous row in the RowSet.
// move to the previous row
rs.MoveToPreviousRow
rs.MoveToPreviousRow