Physical Modeling › Triggers › DBMS Support for Triggers › Define a Progress Table Trigger

Define a Progress Table Trigger

Use the Table Trigger Editor to define the stored procedures that exist for a table in a Progress physical model.

To define a Progress table trigger

1. Right-click the table for which you want to define a trigger and click Trigger Properties.

   The Progress Table Trigger Editor opens.

2. Select the table trigger in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new table trigger. Use the Enter filter text box to filter a very large list of table triggers to quickly locate the one that you want to define.

   Name

   Displays the table trigger name. You can change the trigger name in this field.

   Create

   Specifies to execute the table trigger on CREATE.

   Write

   Specifies to execute the table trigger on WRITE.

   Delete

   Specifies to execute the table trigger on DELETE.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and define properties and referential integrity constraints.
4. Click the Code tab to define the code type for the table trigger.
5. Click the Expanded tab to view expanded code for the table trigger.
6. (Optional) Click the Comment tab and enter any comments that you want to associate with the table trigger.
7. (Optional) Click the UDP tab to work with user-defined properties for the table trigger.
8. (Optional) Click the Notes tab to view history associated with the table trigger and to add or view user notes.
9. Click Close.

   The table trigger is defined and the Progress Table Trigger Editor closes.