Please, I need update my records on the table with User_id, like...

FieldN...
FieldN...
Date_of_Registry TimeStamp,
Date_of_Update TimeStamp,
User_id varchar(20)

and on trigger...

AS
BEGIN
IF (NEW.NUM_NOP = 0) THEN
NEW.NUM_NOP = GEN_ID(TB_NOP_NUM_NOP_GEN, 1);
new.Date_of_Registry = 'now';
new.Date_of_Update = 'now';
new.User_id = '??????????????????????????' <<<< Here, what I need to
do ?
END

Tks,

Gerson Machado




--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.289 / Virus Database: 265.5.0 - Release Date: 9/12/2004



[Non-text portions of this message have been removed]