Rule Editor

Rule Editor is placed within the Table Editor dialog. It allows you to modify table rules.

The main element of the editor is the rules list, which displays all the rules in the table and their properties. These properties are as follows:

Rule Name

The name of the rule. It must be different from any other rule name of the same table.

Kind

Indicates the kind of statement that activates the rule. It can be SELECT, UPDATE, INSERT or DELETE.

Instead

Indicates should rule actions be done instead of statement that activates rule.

Where

Any SQL conditional expression (returning boolean). The condition expression may not refer to any tables except NEW and OLD, and may not contain aggregate functions. NEW is valid in ON INSERT and ON UPDATE rules to refer to the new row being inserted or updated. OLD is valid in ON UPDATE and ON DELETE rules to refer to the existing row being updated or deleted.

Actions memo

The command or commands that make up the rule action. Valid commands are SELECT, INSERT, UPDATE, DELETE, or NOTIFY.

The buttons under the list of rules allow you to perform the following actions:

• Add - add a new ruler to the end of the list;
• Delete - remove the selected rule from the list;
• Up/Down - move the selected rule along the list.