|Subject||Re: [firebird-support] inactivate & activate trigger from stored proc|
>> Is that possible to place TRIGGER INACTIVATE at the beginning andSimilar, but another option would be to run the procedure with a
>> place TRIGGER ACTIVATE at the end of STORED PROCEDURE ?
>> If that's impossible then how I could make it ?
>> PS : I use FB 1.5 on Win Server 2003
> 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.
different user and in the trigger to have something like:
IF (CURRENT_USER <> '...') THEN
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.
Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server