> Trigger is a plain text remembered and executed at certain points of > time. If you know your maximum number of employees at the time when > you create trigger then just put it there instead of question mark. If > you wanted to change that maximum at each trigger execution then it > won't work that way. You should use some other table to contain that > number instead.
Although I still can't undterstand why this "plain text remembered" can't be bound, following your advice, I used sprintf() to print an exact CREATE statement and that works. Thanks. Zhixiang Zhu zzxiang2...@hotmail.com 2010-09-09 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users