Sqlexec

Submits a SQL (Structured Query Language) statement to a database server for the purposes of updating or inserting a record.

Supported Script Types

Property	Details
SQLStatement	The SQL Statement that will be submitted to the database server. This statement should not return records.
FetchIdentityVar	The name of a variable to receive the identity value from an insert. This property is used only when the table you are inserting contains an identity column.
TimeoutSec	The amount of seconds that the action waits to execute before timing out. The value must be between 0 and 60.

Property

Details

SQLStatement

The SQL Statement that will be submitted to the database server.

This statement should not return records.

FetchIdentityVar

The name of a variable to receive the identity value from an insert.

This property is used only when the table you are inserting contains an identity column.

TimeoutSec

The amount of seconds that the action waits to execute before timing out. The value must be between 0 and 60.

Branch	Details
Default	Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the other branches are not defined.
OnError	Path taken when the action fails to execute properly.
OnTimeout	Path taken if there is no response for the number of seconds specified.