Execute Non Query
Execute a non query on a data table.
Last updated
Execute a non query on a data table.
Last updated
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 : 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.
(Default
)
Over Time : The time (in milliseconds) to wait for the activity to run before an error is thrown. The default value is 30 seconds.
Parameters :
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 : The Sql string that is to be executed. Specify the stored procedure name when setting the command type as a stored procedure.
Affected Records : 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.