Sql Query


 

Executes given SQL statement.

Invokes the query and contains all the returned

Required parameters

Parameter type Parameter name Description
Misc CommandText Command to be executed. It can be SQL statement, stored procedure or directly table name.
Misc CommandType Type of the statement. Available options are: Text, StoredProcedure, TableDirect
Misc ConnectionString The connection string.
Misc ProviderName Name of the data provider.

Optional parameters

Parameter type Parameter name Description
Misc DisplayName
Misc StoredProcedureReturnValue Variable specified here will store the value returned by stored procedure used in the query, if there was one.
Misc ConnectionConfigurationName
Misc Parameters

k-93-4

The connection string and data provider window.

 

k-93-5

Command window. It can be chosen whether SQL statement or stored procedure is used.

 

k-93-6

Stored procedure’s parameters window.

k-93-2