|
Submits an SQL (Structured Query Language) statement to a database server for the purposes of updating or inserting a record. |
Supported Script Types
|
|
|
|
|
|
| Generic | Chat | Phone | Voicemail | Work Item |
Properties
- SQLStatement
-
This property is the SQL Statement that will be submitted to the database server.
This statement should not return records.
- FetchIdentityVar
-
This property is 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 number of seconds until the query times out. The default is 10. The maximum number of seconds supported is 30 (though larger numbers can actually be entered in the field).
Branches
- Default
- The Default branch condition will be used unless another branch condition is met.
- OnError
- This branch is triggered if the SQL statement is invalid.
- Error Handling is the best practice.
- OnTimeout
- When the number of timeout seconds is reached, this branch condition is triggered.
Tips and Tricks
- For more details on database servers, see SQLSELECT.
