revRollBackDatabase
Type
command
Summary
Rolls back recent changes to a database.
Syntax
revRollBackDatabase <databaseID>
Description
Use the revRollBackDatabase command to discard changes to a database.
Not all databases support the revRollBackDatabase command. The revRollbackDatabase command is currently supported by Oracle, PostgreSQL and SQLite databases only, on other databases, the command will have no affect.
The revRollBackDatabase command is part of the Database library. To ensure that the command works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.
Parameters
| Name | Type | Description |
|---|---|---|
databaseID | The number returned by the revOpenDatabase function when the database was opened. |
Examples
revRollBackDatabase monthlyExpenses
Value
| Name | Type | Description |
|---|---|---|
the result | If the rollback is not successful, the result function returns an error message that begins with the string "revdberr". |
Related
command: revert, revCommitDatabase, revCloseDatabase
control structure: function
function: revdb_rollback, revdb_commit
glossary: LiveCode custom library, Standalone Application Settings, database, standalone application, return, command
keyword: string
library: Database library
Compatibility and Support
Introduced
LiveCode 2.0
OS
mac
windows
linux
ios
android
Platforms
desktop
server
mobile