Re: Avoiding triggers

Posted in 1996

David Williams — Wed, 21 Aug 1996 22:32:15 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <321aa113.0@eden.adam.com.au>, david roper <daver@adam.com.au> writes >I have some triggers on tables that I do not want to execute when >certain programs access those tables. Does anyone know of a way >to do this? > >Thanks, > >David Create a trigger control table which defines 'enabled/disabled' triggers. At start of trigger select the relevant flag and only do the trigger action if the flag is select to enabled. -- David Williams