Actions - SQL Update

Overview

The SQL Update Action item is used to execute a query which will update data. Ideally a Stored Procedure will be created which is then executed from the Action using a small SQL statement.

Steps

• Add an Item to the Action

• In the Type column, select SQL Update

• Add a Description for reference purposes

• Right-click and select Edit SQL

• Click the Template button to generate the basic SQL required for this Action item.

Note

The Input Parameters that can be used in the SQL differ according to the module that the Action is linked to. The Parameter list can be found in the left panel of the SQL Editor.

SQL Template

execute procedure [PROCEDURE_NAME](:PARAM1, :PARAM2)