On 3 Oct 2011, at 4:12am, Sam Carleton wrote:
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
To list all triggers:
SELECT * FROM sqlite_master WHERE type='trigger'
To list all triggers for a particular table:
SELECT * FROM sqlite_master WHERE
Simon,
Thank you! I have an odd ball case where the tables have two homes: One is
a 'system' db one is a 'document' db. Depending on the case, the user can
make changes to the document db, which in that case, needs the triggers, but
in the case where the system db is being recloned to the
Is there any way to disable a trigger in sqlite?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Sam Carleton scarle...@miltonstreet.com wrote:
Is there any way to disable a trigger in sqlite?
DROP TRIGGER
--
Igor Tandetnik
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
On Sun, Oct 2, 2011 at 9:07 PM, Igor Tandetnik itandet...@mvps.org wrote:
Sam Carleton scarle...@miltonstreet.com wrote:
Is there any way to disable a trigger in sqlite?
DROP TRIGGER
--
Igor
On Oct 2, 2011, at 10:12 PM, Sam Carleton wrote:
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
You are looking to temporarily deactivate a TRIGGER, but there is no such
mechanism. You could simply copy the code for the TRIGGER, then DROP it, and
On 03/10/2011, at 2:12 PM, Sam Carleton wrote:
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger'
Tom
Tom Brodhurst-Hill
BareFeetWare
--
iPhone/iPad/iPod and Mac software
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;
BareFeetWare list@barefeetware.com wrote:
On 03/10/2011, at 2:12 PM, Sam Carleton wrote:
Ok, how do I list what a trigger is so that I can add it back once I want to
reactive it?
select SQL from SQLite_Master where name = 'trigger name' and Type = 'trigger'
And be careful to run this
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
10 matches
Mail list logo