Re: How to identify updated field in a trigger

Mando schreef:

> Hi
>
> Does anyone know whether a trigger can identify which field has been
> updated in a table? I need to write an after update trigger which
> passes the new value from the updated row, but I need to just get the
> field that's been updated.
>
> e.g. table T1 with 3 rows: 1,2,3 and 3 columns: a,b,c
>
> and table T2 with 3 rows: 1,2,3 and 3 columns: a,b,c.
>
> If T1: row1,column b gets updated I need to get that specific value.
>
> Any help much appreciated.
>

Whoops... missed the 'after update' bit- forget :old and :new. The after update of [column] would bring a possible solution Received on Thu Sep 21 2006 - 09:28:04 CDT