COMMIT
Syntax
Command
Mandatory parameter Optional parameter Mandatory keyword Optional keyword |
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 the hardware of the physical server crashes. The updates are safe.
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 case of a fall over situation that is 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. If you would like to prevent this from happening, you would have to use SAVERECOVERYNAME.
| Be aware that a COMMIT on a database will close any open Free Join Query connections to that database. After a COMMIT the connections for Free Join Queries have to be re-established again. Another possibility is to create a database alias for the database, let the Table or Cursor Query use the primary database name and the Free Join Query the alias. |
Examples
wait(5)
commit('RemoteDatabase')