iRobo.Activity.Start Transaction

Start Transaction in a Database. It's the same like a scope to create the Database connection once, then hold inside it all other Database activities and track its transactions.


     Note: 

         Start Transaction Activity is designed to hold other Database activities.


                                                                                                               

Properties

Common

  • Continue On Error -  Allows activity to continue even if there is an error.  Its input is True/False arguments. Default value: False.


Connection Configuration

  • Connection String -  Enter Connection String to connect to Database as String within "". (Mandatory)
  • Existing DB Connection - Enter existing Database connection as Database Connection Variable.

     Note: 

         Either enter Connection String; to create a Database connection.

         Or enter Existing DB Connection, which already exists and saved as a Database Connection Variable.
  • Provider Name -  enter  Database Provider name as String within "".


Misc                                                                                                        

  • DisplayName -  Activity header name.
  • Use Transaction - if its marked, then the activity commits all transactions within even if one of them failed. If unmarked, it stops if one of the activities within failed.


     Note: 

         Use Transaction is designed to track all transactions within the activity if its value is false.

         Otherwise; if its value is true, it ignores errors and commit all transactions.


Output

  • Database Connection -  returns Database Connection Variable.


Steps of Using Start Transaction Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Start Transaction Activity  to the Sequence.
  3. Enter Connection String in Input in Property Panel; to create a Database connection.
  4. Then, enter all Database activities to track its transactions.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process, Database Transaction started, and returns Database Connection Variable.

Created with the Personal Edition of HelpNDoc: Easy CHM and documentation editor