Re: tell updated fields from within preupdate trigger

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: Mon, 25 May 1998 11:22:53 GMT
Message-ID: <35695280.7204566@read.news.global.net.uk>

On Fri, 22 May 1998 18:43:16 GMT, dov_shnaider_at_my-dejanews.com wrote:

>Hi,
>Is there a way to tell what fields an update statement is trying to update
>from within a server-side 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) ?

Use IF UPDATING (’<column name>’)
This is true if the column is included in the update statement, even if the old and new values are the same. Received on Mon May 25 1998 - 06:22:53 CDT