Home » Developer & Programmer » Forms » Poplist issue (Oracle Forms
Poplist issue [message #426297] Wed, 14 October 2009 15:32 Go to next message
Messages: 1
Registered: October 2009
Junior Member

I am trying to allow users to choose the text value of addresstype in a form with poplist.

In the addresstype table I have two columns - ID and name.

In the form I want users to choose the "name" and it will be decoded to the ID with a WHEN-VALIDATE-ITEM trigger on the "name" field which I have set as a non-database field.

The problem is when I query the data back, the POST-QUERY trigger puts the "name" back into the non-database field and the WHEN-VALIDATE-ITEM trigger fires and puts the ID back into the field I just populated from the database with the query.

How can I do this without the WHEN-VALIDATE-ITEM trigger from firing when I am querying?

Re: Poplist issue [message #426392 is a reply to message #426297] Thu, 15 October 2009 04:06 Go to previous message
Messages: 12792
Registered: September 2008
Location: Rainy Manchester
Senior Member
set_item_property(<block.item>, item_is_valid, property_true);

After you assign its value in the post-query trigger.
Previous Topic: form execution in an application is improper
Next Topic: subclass problem
Goto Forum:

Current Time: Thu Jul 20 07:45:30 CDT 2017

Total time taken to generate the page: 0.22993 seconds