Re: tell updated fields from within preupdate trigger

Assuming you are talking about the pre-update trigger in Forms: The only way to identify the old value in your form is to either:

1. select it from the database from within your pre-update trigger. The Forms Reference Manual shows this method under the pre-update trigger documentation. or:
2. Store the original value into another field in your form when the row is fetched, from a post-query trigger.

I have not tried the first option, but have used the second one in various places. I use a hidden non-base-table item in the same block. But you have to be careful to re-set the record status to query after saving off the original value.

Steve Cosner
http://members.aol.com/stevec5088

In article <6k4h2o$8be$1_at_nnrp1.dejanews.com>,   dov_shnaider_at_my-dejanews.com wrote:
> 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.
> 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) ?

-----== 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 - 01:18:11 CEST