Progress
Basic Database
Tools


Creating Table Triggers

Follow these steps to create a table trigger:

  1. Choose Schema Add New Table or choose Schema Modify Table. If you are adding a new table, specify a table name. If you are modifying a table, Progress alphabetically lists all the tables defined for your database. Select the table for which you want to create the trigger.
  2. Choose the Triggers option. Progress displays the Table Triggers dialog box:
  3. Define the trigger attributes. For more information on the Table Triggers dialog box and the trigger attributes, see Schema Menu Reference."
  4. Specify whether a session trigger can override this schema trigger. For more information about session and schema triggers, see the chapter on database triggers in the Progress Programming Handbook.
  5. Specify whether Progress checks the cyclical redundancy check (CRC) code for the trigger.
  6. Press PUT to enter the trigger code. Progress displays the Trigger Code dialog box.
  7. Enter the trigger code.
  8. Choose OK to return to the Table Triggers dialog box.
  9. Choose OK to return to the Add Table or Modify Table window.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095