Home » Developer & Programmer » Forms » Lov call on Disply item (Form6i)
Lov call on Disply item [message #609354] Wed, 05 March 2014 23:39 Go to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Dear all,
i am working on form 6i know i have a issue about lov
.....
i want to create lov on item which have diplay name and id
i maped the both column ..
but i want to hide id and show only name
how can i call the lov at this diplay item.


because i am new in oracle developer.

Re: Lov call on Disply item [message #609358 is a reply to message #609354] Thu, 06 March 2014 00:20 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open LoV Property Palette. Under "Column mapping properties" set ID's "Display width" property value to 0 (zero).
Re: Lov call on Disply item [message #609362 is a reply to message #609358] Thu, 06 March 2014 00:36 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Thanks for reply......


in lov i want to see both id and name,
but i want to do it at form i hide the id and show name on form...
now name is display item at form.
i want to call lov from this display item.

if i take it as text item it work proper but when i query data than lov open auto while fetching the record in detail block.
Re: Lov call on Disply item [message #609372 is a reply to message #609362] Thu, 06 March 2014 02:39 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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 #609387 is a reply to message #609372] Thu, 06 March 2014 03:59 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

Sir i execute query with F8 ki
i detail block
i have two column
id (text_item, database item)which not show on canvas
name (text_item, no database item) which show on canvas
i called lov on name,s default f9 key
for insertion it work good

now when i f8 then lov open on detail block for each record.

please guide me how can i solve it
......................
Re: Lov call on Disply item [message #609390 is a reply to message #609387] Thu, 06 March 2014 04:16 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
do you have a post-query trigger?
Re: Lov call on Disply item [message #609400 is a reply to message #609390] Thu, 06 March 2014 05:50 Go to previous messageGo to next message
mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan
Member

yes i have a post query trigger which get name at query time ....
Re: Lov call on Disply item [message #609408 is a reply to message #609400] Thu, 06 March 2014 07:07 Go to previous message
cookiemonster
Messages: 13917
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);


Previous Topic: Save Employees' Images From Forms
Next Topic: Graph in Oracle forms6i
Goto Forum:
  


Current Time: Thu Mar 28 16:47:30 CDT 2024