Release 10.1A: OpenEdge Development:
Basic Database Tools

> ## Modifying a trigger

> Editing a table or field trigger modifies the database’s schema.

> | To modify a table trigger:

> 1. Choose Schema Modify Table. The Data Dictionary alphabetically lists all the tables defined for your database.

> 2. Select the table for which you want to modify the trigger. The Modify Table window appears.

> 3. Choose Triggers. The Table Triggers dialog box appears.

> 4. Select the trigger you want to modify.

> 5. Press PUT to enter the trigger code. The Trigger Code dialog box appears.

> 6. Edit the trigger code.

> 7. Choose OK to return to the Table Triggers dialog box.

> 8. Choose OK to return to the Modify Table window.

> | To modify a field trigger:

> 1. Choose Schema Field Editor. The Field Editor alphabetically lists all the tables defined for your database.

> 2. Select the table for which you want to modify the trigger. The Field Editor appears.

> 3. Choose Triggers.

> 4. Select the field for which you want to modify the trigger. The Field Triggers dialog box appears.

> 5. Specify the name of the trigger procedure, then press PUT to enter the trigger code. The Trigger Code window appears.

> 6. Edit the trigger code.

> 7. Choose OK to return to the Field Triggers dialog box.

> 8. Choose OK to return to the Field Editor.

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