Progress
Basic Database
Tools
Creating Table Triggers
Follow these steps to create a table trigger:
- 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.
- Choose the Triggers option. Progress displays the Table Triggers dialog box:
![]()
- Define the trigger attributes. For more information on the Table Triggers dialog box and the trigger attributes, see Schema Menu Reference."
- 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.
- Specify whether Progress checks the cyclical redundancy check (CRC) code for the trigger.
- Press PUT to enter the trigger code. Progress displays the Trigger Code dialog box.
- Enter the trigger code.
- Choose OK to return to the Table Triggers dialog box.
- 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 |