Begin database transaction action

Use the Begin database transaction action in the Database package to starts a database transaction to commit all database actions till the end database transaction.

Settings

  • The actions that you insert between the Begin database transaction and End database transaction actions are treated as a single unit. The bot must run all of the actions successfully in order to update the database. This prevents a partial entry in the event that one of the actions fail.

    For example, in double-entry accounting every debit requires the recording of a credit. If a company receives $5000 of products, the accountant must debit $5000 to inventory and credit $5000 to accounts payable.

  • Insert the actions that record these entries between the Begin database transaction and End database transaction actions to ensure that either both entries are recorded or neither is recorded in the database.
  • In the Session name field, enter the name of the session that you used to connect to the database server in the Connect action.
    Note: Begin and End database transaction actions do not support ODBC connectivity.