Re: oracle forms doubt - text box

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 22 Nov 2004 18:57:57 -0800
Message-ID: <1101178588.204782_at_yasure>


Eduardo wrote:

> Hello,
>
> How do I get a value that the user typed in a text box, before it is
> inserted in te database?
>
> I'm using the Oracle forms (f60desm) to develop a graphical interface
> for my turism agency database. There are 3 text box relevants:
> - # of people that will travel
> - price pour each person
> - the total price.
> After the user entered the first 2 values, I would like to add a
> boutton to calculate and fill the total price, using the 2 first
> values, before everything is commited. But I can't find how to read
> values that are not on the db on my procedure.
>
> Thanks
>
> Eduardo

One way is the WHEN-VALIDATE-ITEM trigger. Code like this will work:

BEGIN
   IF :ATS_BL.INVAL IS NOT NULL
   AND :ATS_BL.INVAL > 0 THEN

     :ATS_BL.OUTVAL := NULL;
     :ATS_BL.NETVAL := :ATS_BL.INVAL * 1;
   END IF;
END;
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Tue Nov 23 2004 - 03:57:57 CET

Original text of this message