Subject Re: [firebird-support] Trigger. Before and after
Author Martijn Tonies
> Just to assure me....
> In a trigger that is defined as BEFORE UPDATE can I use
> OLD.SomeValue<>NEW.SomeValue
> Or can I only use this in a trigger defined as AFTER UPDATE ?

In both, actually.

But NEW.<column> = <new value> can only be used in a BEFORE

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions