Data Actions

SqlExecuteNonQuery

Use this action to execute a non-query SQL statement like create, update, delete etc.

Property Description
SQL Non-query SQL statement to be executed. This action doesn’t return any result.
SqlExecuteQuery

Use this action to execute a SQL query statement. Only first record from result dataset is available for use.

Property Description
SQL SQL query statement to be executed. First record data from result dataset is stored as per field mapping configurations under this action.
SelectFieldMapping

Select field mapping action maps a variable with a column. Value as per the given column in first record of result dataset is stored in the respective variable.

Property Description
Field It is name of a column in result dataset.
Variable Variable to hold respective column value.