🚀 go-pugleaf

Hi there,

i'm using D6 and Interbase 6
I want to insert the system time from database server when a new record is
inserted, so i tried the folowing trigger:

SET TERM !! ;
CREATE TRIGGER DOCUMENT_INSERT_DATE FOR DOCUMENTS
 BEFORE INSERT AS
 BEGIN
  NEW.INSERTDATE = date();
 END !!

SET TERM ; !!

But i seem to be getting an error on the ( SO i thought, maybe it's not a
function call, remove the ( ) and the i receive an error on the ;

So probably i'm not using the right functiocall or something...

Anybody who can help me out here...

I also seem to be having some problems with the date time.
I'm used to using UNIX time format, which is a double, but interbase has own
datetime... (or is that just a double). I have some other datetime pickers
in my forms as well and was wondering what is the best way  to implement
time and date. I'm also using php and jsp on some websites to get the data
available on websites aswell so i'm looking for a cross language platform
based solution.

Any help is more then welcome

Thanks
Rim