> No, always use "old" and "new" ...
>
> What I was meaning to say was that an assignment
> (new.column = newvalue) can only be done in a
> BEFORE trigger.
>

OK - Now I'm confused.

I have a trigger defined as BEFORE UPDATE which does this:


if (Old.SomeDate<>New.SomeDate) then
New.MyDateField = New.SomeDate


Sometimes it fires. Sometimes not.

If I change the trigger to a AFTER UPDATE trigger it works every time.



Regards
Michael