Re: [sqlite] Drop Trigger with Select

2008-12-30 Thread Martin.Engelschalk
Hi, My idea would be a to define a function which drops the trigger and returns some dummy value and call ist like this: SELECT MyDropFunction(name) from trigger_status where status = 1 However, i do not know if this will work. Martin timdbu...@gmail.com schrieb: > Hi, > Is there any way t

[sqlite] Drop Trigger with Select

2008-12-30 Thread timdburke
Hi, Is there any way that I could drop a trigger by providing the results of a query? Something similar to the following?: DROP TRIGGER (SELECT name from trigger_status where status = 1); Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org h