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

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.

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.
Last updated