Thanks, Igor! You're awesome...
Igor Tandetnik wrote: > > Simon Chen <simonche...@gmail.com> wrote: >> I just realized that I need to something a bit more complicated. >> Basically, I need myfunction() to take parameters. The parameters >> should be generated based on the entry inserted, like something below: >> >> create trigger triggerName before insert on tableName1 >> when not myfunction(tableName1.name, tableName2.name (where >> tableName2.id == tableName1.parent)) >> begin >> select RAISE(ROLLBACK, 'error message'); >> end; > > when not myfunction(new.name, (select name from tableName2 where > id=new.parent)) > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/how-to-call-c-c%2B%2B-function-in-trigger-tp22815938p22832754.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
