Kbase P119279: Can a session trigger OVERRIDE a schema REPLICATION trigger?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/08/2009 |
|
Status: Verified
GOAL:
Can a session trigger OVERRIDE a schema REPLICATION trigger?
GOAL:
Can a session WRITE trigger OVERRIDE a schema REPLICATION-WRITE trigger?
GOAL:
Can the schema WRITE trigger be overridden?
GOAL:
Can the schema WRITE trigger be overridden by a session trigger?
GOAL:
Can a session trigger OVERRIDE a schema WRITE trigger?
FACT(s) (Environment):
Progress/OpenEdge Versions
All Supported Operating Systems
OpenEdge Category: Language (4GL/ABL)
FIX:
1. The OVERRIDE option causes a session trigger to execute instead of its schema trigger counterpart provided that the schema trigger is defined with OVERRIDE=YES. Thus a session WRITE trigger would execute instead of the schema WRITE trigger provided the schema WRITE trigger is defined as overridable.
2. Progress does not support the definition of session replication triggers. For example, it is not possible to define a session REPLICATION-WRITE trigger.
3. From 1 and 2 above, it follows that there are no session triggers can be defined to OVERRIDE any of the schema REPLICATION triggers and that a session WRITE trigger can not override a schema REPLICATION-WRITE trigger because the OVERRIDE option applies only to the trigger related to the same event.
4. Therefore, the session WRITE trigger:
ON WRITE OF myTable OVERRIDE DO: END.
will override the schema WRITE trigger provided that the schema WRITE trigger is defined as overridable but will NOT override the schema REPLICATION-WRITE trigger.
Note that A trigger defined with the ON statement remains in effect until one of the following occurs:
- Another ON statement defines another trigger (or REVERT) for the same event and widget.
- For a non-persistent trigger, the procedure or trigger block in which the ON statement appears terminates.