COMMIT
| Syntax Color Legend |
|---|
| Command |
| Mandatory parameter |
| Optional parameter |
| Mandatory keyword |
| Optional keyword |
Syntax
COMMIT ( [<RemoteDatabase>] )
Description
This command is used to instruct the database engine to perform a physical update of all the logical updates that the program has performed so far. After a commit, these updates cannot be undone, even if the report or server hardware crashes. The updates are safely stored.
Diagram
Returned value type
None
Parameters
| Parameter | Description |
|---|---|
|
RemoteDatabase |
The name of a remote database to which a connection has been established. |
Remarks
To suspend execution, this statement can be used in combination with WAIT.
Please note that in a failover situation caused by a crashing form at runtime, the application server will start executing that form again from the beginning. This means that in these cases also the transactions before a COMMIT will be executed again. To prevent this, use SAVERECOVERYNAME.
| Be aware that a COMMIT on a database will close any open Free Join Query connections to that database. After a COMMIT, connections for Free Join Queries must be re-established. Another option is to create a database alias for the database, let the table or cursor query use the primary database name, and let the Free Join Query use the alias. |
Examples
commit()
wait (5)
commit ('RemoteDatabase')