Entering the WHEN condition clause |
Once the settings for the trigger action are complete, you may specify a WHEN clause to place constraints on the actions that will cause the trigger to fire. The WHEN statement must follow proper SQL syntax. See the section on Constraint Syntax at the end of Chapter 4 for more information.
Related topic:
Creating
a Trigger
Constraint Syntax
Entering SQL statements for the trigger action
Specifying Trigger Action Settings
Indicating the Referencing Clause