This also seems not to work: create table person ( id integer primary key autoincrement, first_name varchar(30), last_name varchar(30), age integer );
create trigger after insert on person begin select raise(rollback) when exists (select * from person where age < 18); end; Again, SQLite responds with Error: near ")": syntax error Best David > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Dustin Sallings > Sent: Tuesday, September 28, 2010 3:45 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] how to use raise() in a trigger? > > > 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
