<<In FB 1.5 how do I set a TimeStamp variable to now so that I can use it
to time stamp a record ?>>

Here's what I do in a typical BeforeInsert Trigger:

if ((new.ID is null) OR (new.ID = 0)) then
new.ID = gen_id(HRAPPLICANTS_ID_GEN, 1);

if (new.CREATED is null) then
new.CREATED = CURRENT_TIMESTAMP;

if (new.CREATED_BY is null) then
new.CREATED_BY = CURRENT_USER;

<<Regards,
Grant Brown>>

Don't tell me you have a brother named Revoke.


Clay Shannon,
Dimension 4 Software