tell updated fields from within a trigger - how ?

From: <dov_shnaider_at_my-dejanews.com>
Date: Fri, 22 May 1998 16:01:38 GMT
Message-ID: <6k47h1$qh1$1_at_nnrp1.dejanews.com>



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

e.g.
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 - 18:01:38 CEST

Original text of this message