Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Capturing PRE POST values of atext field
Hi Anil,
I'm using Forms 6i and the associated help files suggest that the POST-CHANGE trigger is included only for compatibility with previous version of Forms. I think this is also the case with Forms 4.5 and if you are attempting to validate the old and new values you should use the WHEN-VALIDATE-ITEM trigger.
The old value of a text field can be obtained by calling the GET_ITEM_PROPERTY built-in with DATABASE_VALUE as the second parameter (please see on-line help for details). Obviously the new value is obtained from the text field itself.
Hth,
Andy.
<oracle4444_at_my-deja.com> wrote in message
news:95eojo$706$1_at_nnrp1.deja.com...
> Hi --
>
> I have a simple question, regarding forms 4.5
> Can i capture the OLD and NEW values of a text field, by using
> POST-CHANGE trigger.
>
> An example would be greatly appreciated.
>
>
> Thanks
>
> Anil
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Fri Feb 02 2001 - 16:21:07 CST