|Subject||Re: Trigger. Before and after|
> I bet it fires every time :-)It does ;-)
>You're so right.....
> 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;
A lot of the fields had a value of NULL.