RowSet.MoveToPreviousRow

From Xojo Documentation

Method

RowSet.MoveToPreviousRow()

New in 2019r2

Supported for all project types and targets.

Moves the current row to the previous row in the RowSet.

Notes

Currently only supported by these databases:

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