> > In both, actually.
> >
> > But NEW.<column> = <new value> can only be used in a BEFORE
> > trigger.
>
> So BEFORE UPDATE is:
>
> New.MyColumn=Table.MyColumn
>
> and
>
> AFTER UPDATE
>
> NEW.MyColumn=Old.MyColumn
>
> Right ?

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.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com