Commit

To commit to the database any changes made to this result set since the previous Update Collection action that specified Commit (if any), before moving to the next action, select this check box.

To leave these changes uncommitted until a later time, clear this check box.

This option is used with the Update Collection and Dispatch Update Collection actions.

Note: This check box is enabled only if you select the Update Loaded Collection option.

This option uses a Boolean value to determine whether changes are committed to the database before the system moves to the next action.

When you click OK to return to the Event Actions form, the system returns one of these syntax statements:

  • If this check box is selected: COMMIT( TRUE )
  • If this check box is cleared: COMMIT( FALSE )