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

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
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
use
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: Sun Sep 25 12:56:59 CDT 2016

Total time taken to generate the page: 0.04159 seconds