Simon Chen <simonche...@gmail.com> wrote: > What I want is: > > - whenever I insert/update/delete a table entry, the specified c/c++ > function is called > - if the function returns true, the db action can proceed; otherwise, > the db action should be rolled-back.
create trigger triggerName before insert on tableName when not myfunction() begin select RAISE(ROLLBACK, 'error message'); end; -- or create trigger triggerName before insert on tableName begin select RAISE(ROLLBACK, 'error message') where not myfunction(); end; Similarly for update and delete. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users