> Is there some way to create a trigger what works both after insert and
> after update?
> someting like:
>
> CREATE TRIGGER MyTrigger FOR MyTable AFTER INSERT OR AFTER UPDATE
> POSITION 0 AS
> BEGIN
>
> if (new.MyDateField='30.12.1899') then update MyTable set
> MyDateField=null where ID=new.ID;
>
> END
>

Why don't you just set the default for the field as 'NOW'. I think you are
seeing a null date being returnf to delphi.
Alan