PerfectForms™ supports database transactions explicitly using the Transaction behavior command. When building the form, a user is able to specify the following actions:

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 a form 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 Form Submits Data behavior event in the Form Properties (see Form Properties).

Updated: 16/04/2012  Page url: http://www.perfectforms.com/Documentation/manual/html/?i_database_transactions.htm
PerfectForms™ -- forms software, workflow software, and business process management