Kbase P9438: Can two triggers be defined for the same database event?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2003 |
|
Status: Unverified
GOAL:
Can two triggers be defined for the same database event?
FIX:
YES you can define a schema trigger and a session trigger for the same table or field event. Both triggers normally fire unless the Schema Trigger is OVERRIDDEN by the Session Trigger. In this case only the session trigger fires.
When both triggers fire the session trigger fires first except for a FIND event where the schema trigger fires first.
Only one schema trigger may be defined for a database event.