Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trigger a Display item when the value is changed by entering data to a Text item

2898128Mar 6 2015 — edited Mar 9 2015

this is my form

Untitled 1.png

the SEATS LEFT box is a display item with a fixed to total value of 217. When I enter a value in either of the three boxes which are Adult, Child, and Infant, the SEATS LEFT will subtract the total values of those three text items.

So I want it to stop when it reaches 0 (ZERO) and gives a message. I tried putting WHEN-VALIDATE AND POST_CHANGE triggers to the SEATS LEFT with this code, but nothing happens. It even goes down to a negative value.

-------

IF :SEATS_LEFT < 0 THEN

 MESSAGE('NO SEATS AVAILABLE');

END IF

-------

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 6 2015
Added on Mar 6 2015
4 comments
1,734 views