Subject RE: [firebird-support] trigger error ... column unknown
Author Thomas Steinmaurer
> 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.

The CURRENT_USER keyword isn't available in IB 6.

Use USER instead. That will work for both.

Thomas Steinmaurer

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