> 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.


HTH,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com
Logging/Auditing Suite for Advantage Database Server
http://www.adslogmanager.com

- I support Firebird, I am a FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation