Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : OpenEdge database : OpenEdge edit schema wizards : OpenEdge Create/Modify Trigger wizard
 
OpenEdge Create/Modify Trigger wizard
The Create/Modify Trigger wizard allows you to set the properties for new ABL triggers or modify the properties of existing ABL triggers in an OpenEdge database.
Display the Create/Modify Trigger wizard from a context menu in the DB Structure view.
Note: To use the Create/Modify Trigger wizard, there must be at least one OpenEdge project opened. If no project is open, an error message appears.
The Create/Modify Trigger wizard allows you to set the following properties:
Table
A valid table name from a list of tables in the PUB schema.
Column Trigger
When the option is selected, displays all columns for the selected table in the Column combo box. The Event field is set to ASSIGN (since that is the only event for a column trigger).
Column
A list of the columns in the selected table.
Event
A list of available trigger types including: CREATE, DELETE, WRITE, FIND, REPLICATION-CREATE, REPLICATION-DELETE, REPLICATION-WRITE, and ASSIGN (for column triggers).
Create new trigger file
When the option is selected, the system creates a new file by the system in a specified project and folder. You specify the project and folder in the New File dialog, which appears when you select the Browse button. When you specify the project and folder, they appear in the read-only Parent Folder field. The read-only Propath field displays the PROPATH setting for the selected OpenEdge project.
Attach existing trigger
When the option is selected, the system attaches a specified trigger to this trigger. You select an existing trigger in the Trigger Selection dialog box, which appears when you select the Browse button. After you select a trigger, the trigger file name appears in the read-only File Name field.
Override
When the option is selected, users can redefine and overwrite triggers at run time.
Check CRC
When the option is selected, the system checks the validity of the trigger at run time. CRC (Cyclical Redundancy Check) is an algorithm that verifies the integrity of executables. It compares a stored number in the executable with a number calculated from the schema. If the numbers do not match (after a schema change, for example), the executable must be recompiled.
After you complete the Create/Modify Trigger wizard, the ABL Editor opens.
Note: For more information about triggers, see the ABL manuals in the OpenEdge Product Documentation section of the Progress Communities Web site.