Begin Transaction

Call the Begin Transaction system function to start a manual transaction. Calling this system function initiates the beginning of the table updates that are part of the transaction. This system function has one MathNumeric type parameter named Transaction ID. You can use a Report Level Math Numeric variable to pass into the Transaction ID parameter. Even though you must pass in a value for Transaction ID, the value is not currently being used by the system. This is because at any one time, only one transaction can be started from Event Rules.

After calling the "Begin Transaction" system function, the report can use Table I/O statements or Business Functions to conduct database table operations.

To include the Table I/O statements in the current transaction.

1. Click the system function you have assigned to the event rule.

2. Click the Table I/O icon.

3. On Insert Table IO, in the Advanced Operations section, select Open, and then click Next.

4. On Data Source, click the Advanced Options button.

5. On Advanced Options, click the Include in Transaction option, and then OK.