Subject Re: [firebird-support] Disable trigger?
Author Milan Babuskov
homerjones1941 wrote:
> I have created triggers to log inserts, updates, and deletes on a good number of tables. The purpose is to log who changes what, and to be able to track changes to certain important fields, regardless of who changes them. However, I don't need to log certain program-created updates. For example certain fields are automatically updated each day for hundreds or even thousands of records. Therefore, the logging triggers created hundreds or even thousands of log entries each day that are just clutter. Is there a way my stored procedure can disable a trigger, do its job, and then re-enable?

http://www.firebirdfaq.org/faq189

HTH

--
Milan Babuskov

==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================