From: "Andy Collins" Newsgroups: comp.databases.oracle.misc References: <95eojo$706$1@nnrp1.deja.com> Subject: Re: Capturing PRE POST values of atext field Lines: 37 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Message-ID: Date: Fri, 2 Feb 2001 22:21:07 -0000 NNTP-Posting-Host: 212.126.143.152 X-Complaints-To: abuse@clara.net X-Trace: nnrp3.clara.net 981152494 212.126.143.152 (Fri, 02 Feb 2001 22:21:34 GMT) NNTP-Posting-Date: Fri, 02 Feb 2001 22:21:34 GMT 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. wrote in message news:95eojo$706$1@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/