Subject | altering triggers from sp |
---|---|
Author | kaczy27 |
Post date | 2004-08-18T10:28:40Z |
Hello
is it possible to activate/deactivate trigger from stored procedure
or trigger? I tried inserting alter trigger into the stored
procedure body, but received an error (Token unknown).
On the other hand maybe there is a better solution using
transactions or triggers sequences. I have the trigger the do update
on the table after some insert/update actions. What I want is to
fire the trigger after a sequence of individual inserts/updates
complete. The first thing I came up with is to deactivate trigger,
and activate it before the last in the sequence.
Any help would be appreciated.
I have Firebird 1.5.1.
CUIN Kaczy
is it possible to activate/deactivate trigger from stored procedure
or trigger? I tried inserting alter trigger into the stored
procedure body, but received an error (Token unknown).
On the other hand maybe there is a better solution using
transactions or triggers sequences. I have the trigger the do update
on the table after some insert/update actions. What I want is to
fire the trigger after a sequence of individual inserts/updates
complete. The first thing I came up with is to deactivate trigger,
and activate it before the last in the sequence.
Any help would be appreciated.
I have Firebird 1.5.1.
CUIN Kaczy