|
|
|
Re: Lov call on Disply item [message #609372 is a reply to message #609362] |
Thu, 06 March 2014 02:39 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
I'm not following how you expect this to work.
You can't call an LOV from a display item, it would make no sense to do so.
Also the LOV shouldn't open when you query, that's not standard behaviour. How are you querying the data? execute_query or some other method?
|
|
|
|
|
|
Re: Lov call on Disply item [message #609408 is a reply to message #609400] |
Thu, 06 March 2014 07:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
So you have a non-database item that you are populating in the post-query trigger.
That item has an LOV attached and I assume that the validate_from_list property is set to true.
Changing the value of an item post query changes it's item_is_valid property to false. This is to ensure forms re-validates it before saving the record. This is what is causing the LOV to appear.
It's easily fixed, just add this code to the end of the post-query trigger:
set_item_property('<block_name.name>', item_is_valid, property_true);
|
|
|