PreviousDatabaseRow()

Syntax

Result = PreviousDatabaseRow(#Database)
Description
Retrieves information about the previous database row in the #Database. The flag #PB_Database_DynamicCursor has to be specified to DatabaseQuery() to have this command working. To access to fields inside a row, GetDatabaseLong(), GetDatabaseFloat(), GetDatabaseString() can be used.

Parameters

#Database The database to use.

Return value

If Result is 0, then no more rows are available (i.e. reached the start of the table).

Remarks

If this function returns zero 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.

See Also

GetDatabaseBlob(), GetDatabaseDouble(), GetDatabaseFloat(), GetDatabaseLong(), GetDatabaseQuad(), GetDatabaseString()

Supported OS

All

<- OpenDatabaseRequester() - Database Index - SetDatabaseBlob() ->