Subject Re: Trigger. Before and after
Author Michael Vilhelmsen
> 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.