Execute Non Query
Execute a non query on a data table.
Last updated
Visualyze Documentation
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 : 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.
Parameters are used only when Command Text as Stored Procedure.
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.
PostgreSQL uses Sql command for calling stored procedure with parameter placeholder. For example CALL my_proc(@p1,@p2,....)
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.
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.
