Re: tell updated fields from within a trigger - how ?

Hi,

I think the method depends really on why you need to know.

Also the structure of the update statement is governed by whether column security is enabled and whether the block property 'update changed columns' is true or false.
In the default scenario, the update statement contains all attributes. In the alternative the update statement only contains those that have been changed.

Either way there is no simple method for seeing the actual statement from the pre-update and anyway, as you say, the change might have been to set the value to itself making the update statement structure irrelevant.

There is method using when_timer_expired to mirror the data set and control the view of the mirror to only contain real progressive changes, and there are a lot of alternative flavours in this method.

Hence my starting point of 'why do you need to?'. The reason for the need is often a better pointer to the solution rather than the need itself.

I'm not sure that the above is particularly helpful, but perhaps you could post some more info.

regards

Rod Corderey
Lane Associates
Lane_Associates_at_Compuserve.com
http://www.Lane-Associates.com

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 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 Sat May 23 1998 - 13:06:20 CEST