Hi,



I get an �Unknow token � end� here. I am using ISQL(IBExpert) to create this
trigger. I want to insert a timestamp when a record is inserted into SMSQ
table.



CREATE TRIGGER SMSQ_RecDateIns FOR SMSQ

ACTIVE AFTER INSERT POSITION 0

AS

begin

/* Trigger text */

New.receivedate = cast("NOW" as timestamp)

end



Thanks,

Dion.




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.2/251 - Release Date: 04/02/2006



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