Thread: Invocation recognition.

Invocation recognition.

From
Marek PUBLICEWICZ
Date:
Hello,

    I wonder if it would be possible inside a trigger fired
BEFORE UPDATE to detect, whether the action (UPDATE), which
activated the trigger was invoked from inside another trigger.
Is it possible to distinguish invocation from the other trigger from
the direct invocation made by the user 'by hand'? I need it in order to
determine in the BEFORE UPDATE trigger, whether to allow to perform the
update.
   The triggers are written in C, if this matters.

any help appreciated ;)
                    mark