tell updated fields from within preupdate trigger

From: <dov_shnaider_at_my-dejanews.com>
Date: Fri, 22 May 1998 18:44:40 GMT
Message-ID: <6k4h2o$8be$1_at_nnrp1.dejanews.com>



Hi,
[Quoted] Is there a way to tell what fields an update statement is trying to update from within a **server-side** pre-update database trigger ?

e.g.
[Quoted] the user issues : update table set field1=vl1 field2=val2 field3=val3 when val1,val2,val2 may or may not be identical to the current values in the table row.

can the pre-update trigger identify the particular field names: field1,field2,field3 (even when the new and old values are identical) ?

Thanks

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 20:44:40 CEST

Original text of this message