On Oct 2, 2011, at 10:29 PM, Igor Tandetnik wrote: > Sam Carleton <scarle...@miltonstreet.com> wrote: >> Is there any way to "disable" a trigger in sqlite? > > If you have control over the trigger's definition, you could do something > like this: > > create trigger MyTrigger on ... > when (select enabled from TriggerControl where name='MyTrigger') > begin > ... > end; > > where TriggerControl(name text, enabled integer) is a table with a row for > each trigger you want to manage. You can effectively turn a trigger on and > off with > > update TriggerControl set enabled=? where name='MyTrigger'; >
very clever. -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users