OraFAQ Forum: Forms » Calling Two Different LOVs at same Textbox

Home » Developer & Programmer » Forms » Calling Two Different LOVs at same Textbox (Form 6i )

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

Calling Two Different LOVs at same Textbox [message #488585]

Mon, 10 January 2011 00:36

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Hi Experts,

Is it possible to populate two different LOVs on same textbox?

Textbox : ITEM_DESC

LOV1:
select desc, code from items order by 1;

LOV2:
select code, desc from items order by 1;

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #488594 is a reply to message #488585]

Mon, 10 January 2011 01:25

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Yes you can populate two different LOVs on same textbox.

As a Sample Code


Declare
Lov_Value Boolean;

begin
IF :PO_header.Supplier_ID =1 then
	Lov_value:=Show_lov('Lov1');
    else
	Lov_value:=Show_lov('Lov2');
END IF;
 end;

Hope it 'll help you.

Regards,
Irfan

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #488595 is a reply to message #488594]

Mon, 10 January 2011 01:49

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

When I press F9 it shows LOV1.

Is it possible to Call LOV2 by pressing any other key? Like Ctrl+F9, etc

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #488597 is a reply to message #488595]

Mon, 10 January 2011 02:06

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,
Quote:

Textbox : ITEM_DESC
When I press F9 it shows LOV1.

1- Go TextItem property and Set TextItem List of Values (LOV) Property <Null>
2- Write Form Trigger on TextItem Key-Next-Item,through Sample code call Lov's.

Quote:

Is it possible to Call LOV2 by pressing any other key? Like Ctrl+F9, etc

No.

Regards,

Irfan

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #488670 is a reply to message #488597]

Mon, 10 January 2011 08:02

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Have you solved your problem ?

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #492720 is a reply to message #488670]

Wed, 02 February 2011 00:40

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

use set_item_property to change the attached LOV.

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #492830 is a reply to message #492720]

Wed, 02 February 2011 23:43

theowais
Messages: 75
Registered: October 2009
Location: Multan

Member

Problem is not solved yet.

Report message to a moderator

Re: Calling Two Different LOVs at same Textbox [message #492851 is a reply to message #492830]

Thu, 03 February 2011 01:12

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What did you do (so far) in order to solve it? What happened so that you didn't succeed? People suggested two solutions, both valid (as far as I can tell).

Report message to a moderator

Previous Topic:	which trigger should I put on a text item so that when the cursor comes inside it..
Next Topic:	Save changes.. but I have no changes to save..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 15:59:24 CST 2025