iRobo.Activity.Insert

Inset data into a Database.



                                                                                                               

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 "".


Input

  • DataTable -  Enter DataTable Variable. (Mandatory)
  • Table Name -  Enter Table name as String within "". (Mandatory)

     Note: 

         DataTable data and Table Name Columns to be inserted in the Database must match data in the Database.


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output

  • Affected Records - returns the number of affected records in Database as an Integer Variable.  


Steps of Using Insert Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Insert Activity  to the Sequence.
  3. Enter DataTable Variable, to insert its data in Database, in DataTable field in Input in Properties Panel.
  4. Enter Table name in Table Name field in  in Input in Properties Panel.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process, data inserted into Database, and returned the number of affected records in Database as Integer Variable.

Created with the Personal Edition of HelpNDoc: Full-featured Help generator