OraFAQ Forum: Forms » Lov call on Disply item

Home » Developer & Programmer » Forms » Lov call on Disply item (Form6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Lov call on Disply item [message #609354]

Wed, 05 March 2014 23:39

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.

Report message to a moderator

Re: Lov call on Disply item [message #609358 is a reply to message #609354]

Thu, 06 March 2014 00:20

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: Lov call on Disply item [message #609362 is a reply to message #609358]

Thu, 06 March 2014 00:36

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.

Report message to a moderator

Re: Lov call on Disply item [message #609372 is a reply to message #609362]

Thu, 06 March 2014 02:39

cookiemonster
Messages: 13963
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?

Report message to a moderator

Re: Lov call on Disply item [message #609387 is a reply to message #609372]

Thu, 06 March 2014 03:59

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
......................

Report message to a moderator

Re: Lov call on Disply item [message #609390 is a reply to message #609387]

Thu, 06 March 2014 04:16

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

do you have a post-query trigger?

Report message to a moderator

Re: Lov call on Disply item [message #609400 is a reply to message #609390]

Thu, 06 March 2014 05:50

mehboob110233
Messages: 55
Registered: February 2014
Location: Pakistan

Member

yes i have a post query trigger which get name at query time ....

Report message to a moderator

Re: Lov call on Disply item [message #609408 is a reply to message #609400]

Thu, 06 March 2014 07:07

cookiemonster
Messages: 13963
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);

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:18:55 CST 2025