PerfectApps supports database transactions explicitly using the Transaction behavior command. When building an app, a user is able to specify the following actions:
•Start Transaction
•Rollback
•Commit
The Transaction command ensures database consistency when writing data with the Connect command. It operates the same way as normal database transactions. Any database write operations are queued by the connection agent. Once the data is written to the database, the transaction is committed.
If an app is submitted and a transaction is neither rolled back nor committed, the connection agent will ignore any outstanding database commands.
The most common place to put the Commit instruction is in the App Submits Data behavior event in the App Properties (see App Properties).
Return to: Calling the Connection from an App, Integration
