Ichiro Kobayashi wrote:

Is it possible to place TRIGGER INACTIVATE at the beginning and place TRIGGER ACTIVATE at the end of STORED PROCEDURE?

Svein Erling Tysvær answers:

I think it would be better to make the stored procedure first update a field in a table and modify the trigger to check the value of that field.

Thomas Steinmaurer adds:

Similar, but another option would be to run the procedure with a different user and in the trigger to have something like:

...
IF (CURRENT_USER <> '...') THEN
BEGIN
   ...
END

In Firebird 2.x, one could also use user-definable context variables with RDB$SET_CONTEXT, RDB$GET_CONTEXT, but the OP uses 1.5.

Like this post? Share on: TwitterFacebookEmail


Related Articles


Author

Firebird Community

Published

Category

Gems from Firebird Support list

Tags