[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: Re: [sqlite] Drop Trigger with Select
From: "Martin.Engelschalk" <engelschalk () codeswift ! com>
Date: 2008-12-30 16:56:27
Message-ID: 495A52BB.5080907 () codeswift ! com
[Download RAW message or body]
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
timdburke@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
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic