Re: How to identify updated field in a trigger

From: <frank.van.bortel_at_gmail.com>
Date: 21 Sep 2006 07:26:00 -0700
Message-ID: <1158848760.645795.282400@i3g2000cwc.googlegroups.com>

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.

Did you try with the :old and :new syntax? Would the ... after update of... syntax bring anything? What did you try so far - any errors? Received on Thu Sep 21 2006 - 09:26:00 CDT