Re: [sqlite] how to use raise() in a trigger?

[Dustin Sallings]

On Sep 28, 2010, at 15:02, David Ventimiglia wrote:

> CREATE TRIGGER <trigger-name> AFTER INSERT on <table-name> WHEN EXISTS
> (select * from <some-table>)
> 
> BEGIN
> 
>                RAISE(ROLLBACK);
> 
> END


        try something like this:

        create trigger <trigger-name> after insert on <table-name>
                begin
                        select raise(rollback) when exists (select * from 
<some-table>);
                end

-- 
Dustin Sallings

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