David Ventimiglia <[email protected]> wrote: > Thanks. I'm afraid that when I try your suggestion, it doesn't work: > > create table person (id integer primary key autoincrement, > first_name varchar(30), last_name varchar(30), age integer); > create trigger adult after insert on person when exists (select > * from person where age < 18) begin select raise(rollback); end;
Make it select raise(rollback, 'some error message'); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
