Thanks, Igor! You're awesome...
Igor Tandetnik wrote: > > Simon Chen <[email protected]> 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 > [email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
