| Subject | How to skip a trigger in the same trigger? |
|---|---|
| Author | Gabor Boros |
| Post date | 2016-04-14T10:46:14Z |
Hi All,
I have a BEFORE UPDATE trigger for MYTABLE1 with an IF ... UPDATE
MYTABLE1 and after an IF ... INSERT INTO MYTABLE2 in it. If the UPDATE
MYTABLE1 executed the trigger fire himself and the INSERT executed
twice. How to skip it? RDB$SET_CONTEXT/RDB$GET_CONTEXT is a good
solution? I never used them before.
Gabor
I have a BEFORE UPDATE trigger for MYTABLE1 with an IF ... UPDATE
MYTABLE1 and after an IF ... INSERT INTO MYTABLE2 in it. If the UPDATE
MYTABLE1 executed the trigger fire himself and the INSERT executed
twice. How to skip it? RDB$SET_CONTEXT/RDB$GET_CONTEXT is a good
solution? I never used them before.
Gabor