Adding Triggers

Triggers go into effect when a user attempts to insert, update, or delete data.

DBEdit must be open.
By preventing incorrect, unauthorized, or inconsistent changes to data, triggers help maintain the integrity of the database. For example, one error message indicates that a trigger is missing.

Triggers are usually added during the Compare process.

  1. In the Indexes grid, click the Triggers tab.
  2. In the blank Trigger field (in a row with an asterisk), type the name of the trigger.
  3. In the Trigger Type list, select one of the following options:

    • After: Applied after data is committed

    • Instead Of: Used on views

    • Before
  4. Indicate the user actions that should launch the trigger by selecting one or more of the following:
    • Insert
    • Update
    • Delete
  5. In the Documentation field, type comments or any relevant information about the trigger.
  6. Click the Save button:
    Diskette.