PreviousDatabaseRow()

Syntax

Result = PreviousDatabaseRow(#Database)

Retrieves information about the previous database row in the #Database. If Result is 0, then no more rows are available (i.e. reached the start of the table). To access to fields inside a row, GetDatabaseLong(), GetDatabaseFloat(), GetDatabaseString() can be used.

Note: If this function returns 0 despite additional rows being available before the current one, then the ODBC driver does not support data retrieval in a backwards direction. It is not mandatory for an ODBC driver to support this function (unlike NextDatabaseRow()). Of course, if this function works, it will work on every computer using the same driver.

SQLite databases don't support this command.

Supported OS

All