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 ?
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