Subject | trigger error ... column unknown |
---|---|
Author | James |
Post date | 2004-01-08T08:36:52Z |
Hi
I have a table which a add a column createby and createon, then I create
a beforeinsert trigger with this code
new.createby = current_user;
new.createon = current_timestamp;
when I compile it is says that sql error code = -206. column unknown.
I don't have any idea what's going on here. I am working under IB 6 open
source ed. When I try it in FB 1.5 rc 5 this works. Have anyone of you
counter this in IB 6 open source ed. What can I do with this problem.
Thanks in advance.
James
I have a table which a add a column createby and createon, then I create
a beforeinsert trigger with this code
new.createby = current_user;
new.createon = current_timestamp;
when I compile it is says that sql error code = -206. column unknown.
I don't have any idea what's going on here. I am working under IB 6 open
source ed. When I try it in FB 1.5 rc 5 this works. Have anyone of you
counter this in IB 6 open source ed. What can I do with this problem.
Thanks in advance.
James