SQLData object database navigation commands

The Boolean commands RecordSelectNextCmd and RecordSelectPreviousCmd allow for scrolling of the database at runtime. Scrolling does not use the active query (that is, it scrolls the entire database). The identity column provides the position information required to determine the next and previous records. The values of the selected record returned by the scroll operation are transferred to the temporary attributes.

Attempting to scroll past the last record in the database or before the first record in the database results in an error, and the temporary attribute values remain unchanged.

Using the RecordSelectNextCmd command attribute when no record is selected returns the first record in the database.

Using the RecordSelectPreviousCmd command attribute when no record is selected returns the last record in the database.