hi all,
i want to create trigger for my firebird database.
but i need to insert it base on user who is login.

example :
i have table
PERSON,
the field is : ID,NAME,CREATEBY,CREATEDATE
USER,
the field is : ID,USERNAME

i can create trigger after insert,but how can
i insert the CREATEBY with USER ID


thx