The Transaction command enables you 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 written to the database, the transaction is committed.
|
The Main section contains options for selecting the connection, setting the connection type and specifying other miscellaneous options.
Connection
|
[Connection Selection]
|
Select from the list of existing connections. If you do not see the connection you need, you may need to click the Refresh  button or exit the Form Designer and create the new connection from the PerfectForms™ Connections Dashboard.
|
Creating PerfectForms™ Connections
|
Type
|
Start
|
Select this radio button to indicate that a new database transaction is starting at this point.
|
Database Transactions
|
Rollback
|
Select this radio button to remove any outstanding database write operations and prevent them from actually being written to the database. If a form is submitted and a transaction is neither rolled back nor committed, then the connection agent will ignore any outstanding database commands.
|
Database Transactions
|
Commit
|
Select this radio button to instruct the connection agent to write any outstanding database commands to the database. The standard place to put transaction behavior with the Commit property enabled is in the Form Submits Data behavior event.
|
Database Transactions
|
Misc
|
Show Error Messages
|
Select this check box to have PerfectForms™ show all errors. If you clear this check box, then you will need to manage your own error handling.
You can inspect the error code after the command has run. Check for problems with the connection using a Branch command and inspecting the Special Value Last Command Was Successful and last command's error code.
| • | Generates a general connection error (Error Code 200) |
| • | Returns no data although the connection worked fine (Error Code 201) |
|
Connection Error Handling
|
Summary
|
Auto-Summary
|
Auto-summary refers to the text that will be shown on the command in the Behaviors canvas. By default, this check box is selected.
For commands that use a condition or calculation, Auto-Summary will display the formula selected in the Condition Properties. If no condition exists, nothing will be displayed.
If you wish to have other summary text display, clear the Auto-summary check box and type the custom text in the list box below. Your text will be retained if you later decide to enable Auto-summary.
|
|
[Summary Text]
|
This is where manual summary text can be entered when the Auto-summary option is not turned on.
|
|
|
Updated: 06/12/2011
Page url:
http://www.perfectforms.com/Documentation/manual/html/?fl_transaction.htm
PerfectForms™ -- forms software, workflow software, and business process management
