|Subject||RE: [firebird-support] trigger error ... column unknown|
> HiThe CURRENT_USER keyword isn't available in IB 6.
> 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.
Use USER instead. That will work for both.
Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server
- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation