iRobo.Activity.Execute Non Query

Execute Non Query in 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.
  • Time Out MS - Enter time out in Millisecond as Integer, to continue even if there is an error.


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 DBConnection, which already exists and saved as a Database Connection Variable.
  • Provider Name -  Enter  Database Provider name as String within "".


Misc                                                                                                        

  • DisplayName -  Activity header name.


Input

  • Parameters -  Enter parameters if required.
  • SQL Command -  Enter SQL command as String within "". (Mandatory)


Misc

  • Command Type - Select SQL command type from the list; Text, Stored Procedure, or Table Direct.
  • DisplayName - Activity header name.


Output

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


Steps of Using Execute Non Query Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Execute Non Query Activity  to the Sequence.
  3. Enter SQL command in SQL Command field in Input in Properties Panel.
  4. Select SQL Command Type from Command Type field in Properties Panel.
  5. Click the Save button from iRobo Studio Menu to save Workflow.
  6. Click the Play button to start the automated process, SQL command executed, and returned the number of affected records in Database as Integer Variable.

Created with the Personal Edition of HelpNDoc: Easily create Web Help sites