This field displays a template for the SQL for the action that is to precede or follow the operation selected on the Trigger page (inserting rows, deleting them, or updating them). In this field, specify the entire action. Use one or both of these methods:
The template includes a keyword and placeholder (WHEN (search-condition)) for an optional search condition, keywords (BEGIN ATOMIC and END) to delimit SQL statements, and a placeholder (triggered-SQL-statement;) for these statements.
Erase any part of the template that you don't need. If you need to use WHEN, you must replace (search-condition) with your search condition. If you need BEGIN ATOMIC and END, you must replace triggered--SQL--statement; with your SQL statements.
To remove the last change made to this field, click on Undo. To remove all content, click on Clear.
[ Top of Page | Table of Contents | Glossary | Index ]