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 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
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>   

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users