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 prevents 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 users to confirm the Action's execution.

• Information: This message displays information. It can be used as the final step in an Action to confirm that the action was successful.

Steps

1. Add an Item to the Action.

2. In the Type column, select Message - Type. 

3. Add a Description for reference purposes.

4. Right-click and select Edit SQL.

5. 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 based on 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

Related Topics

• Reference: Actions

• Reference: Actions > Create New Record

• Reference: Actions > SQL Update