Actions - Messages

Overview

Actions can be used to generate messages. SQL is used to generate the message text. When the message text is empty, the Message won't be generated. Message types include.

• Error - This message will prevent any further items in the Action list to be executed.

• Warning - This message warns the user of a potential problem and includes an option to cancel further execution of the Action) or to continue.

• Confirmation - This message allows you to confirm whether or not you would like to execute the Action.

• Information - This message simply provides information. It can be used as the final step in an Action to confirm that it was successfully executed.

Steps

• Add an Item to the Action

• In the Type column, select Message - Type

• 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

select '' as NOTE from RDB$DATABASE