Subject Re: Trigger. Before and after
Author Michael Vilhelmsen
> I bet it fires every time :-)

It does ;-)

>
> That given, can OLD.SomeDate be NULL? If so, you need to do:
>
> if ( (Old.SomeDate <> New.SomeDate) or
> (Old.SomeDate is null and New.SomeDate is not null) or
> (Old.SomeDate is not null and New.SomeDate is null) )
> then New.MyDateField = New.SomeDate;


You're so right.....
A lot of the fields had a value of NULL.

Thank you.

Michael