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 is used to achieve database consistency when writing data to a database using the Connect command. It operates in the same way as normal database transactions typically operate. Any database write actions that are performed are queued by the connection agent. Once the data is actually written to the database, the transaction is committed.
If an app is submitted and a transaction is neither rolled back nor committed, then the connection agent will ignore any outstanding database commands.
The most common place to put the Commit is in the App Submits Data behavior event in the App Properties (see App Properties).
Return to: Calling the Connection from an App, Integration