Progress
Programming
Handbook
Trigger Interaction
You can define a schema and a session trigger for the same table/event or field/event pair. How the triggers interact depends on how you define them. Ordinarily, both triggers execute. When both execute, the session trigger executes first, except for a FIND event. A schema trigger defined for a FIND executes before a session trigger for the same table. This ensures that any the schema FIND trigger you define for security reasons applies to the record first. For a WRITE, DELETE, CREATE, or ASSIGN event, the schema trigger can override the session trigger. For a FIND event, the schema trigger can preempt the session trigger.
However, the session trigger executes in place of the schema trigger if you do the following:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |