Subject | Re: Trigger. Before and after |
---|---|
Author | Michael Vilhelmsen |
Post date | 2005-04-06T14:09Z |
> 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.
Thank you.
Michael