Execute Non Query

Execute a non query on a data table.

Execute a non query on a data table. UPDATE, INSERT and DELETE are the execute non query statements and that returns the number of rows affected by the command. -1 is the return value of all other types of statements.

Input

• Input : DbHandle Variable The DbHandle object to reference the opened database connection.\
• Command Type : Specifies how a command string is interpreted.

  • Text - Executes the query specified in the SQL parameter.

  • Stored Procedure - Invokes the procedure name specified in the SQL parameter.

• Database Type : The type of database to establish a connection.

  • MySql (Default)

  • MicrosoftSqlServer

  • PosgreSql

  • SqLite

  • Oracle

  • MongoDb

  • H2

• Over Time : Integer Argument The time (in milliseconds) to wait for the activity to run before an error is thrown. The default value is 30 seconds.

• Parameters : String Argument

  Clicking the selector button in the activity opens the Database Parameters Dialog in which Parameter Name, Direction, Type, and Value to be created.

Parameters are used only when Command Text as Stored Procedure.

Parameters Window

Information :

• Database Type: The type of database in which parameters to be inserted.

• Name: The name of parameters.

• Direction: The direction of the parameter passed to the stored procedure. In, Out and InOut are the directions used in the parameter window.

• Type: The type of the parameters passed to the stored procedure. Types are dependent on the database type.

• Size: The size of the value of the parameters passed to the stored procedure.

• Value: The value of the parameters passed to the stored procedure.

• Sql String : String Argument The Sql string that is to be executed. Specify the stored procedure name when setting the command type as a stored procedure.

PostgreSQL uses Sql command for calling stored procedure with parameter placeholder. For example CALL my_proc(@p1,@p2,....)

SQL String Editor Window

Output

• Affected Records : Integer Variable The variable that stores the number of rows affected by the execute non query. For all other types of statements, it stores the value is -1.