OraFAQ Forum: Forms » how to connect lov to push button?

Home » Developer & Programmer » Forms » how to connect lov to push button?

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

how to connect lov to push button? [message #322818]

Mon, 26 May 2008 05:42

nyc212
Messages: 14
Registered: May 2008

Junior Member

hi

i want to connect push button to lov - that when i push the button the list of values will appear.

i have created a record group and lov ( using the wizard ). i connected the RECORD G. to the LOV, now what do i have to do in order that the button i had added to the canvas will open the List Of Value when i push it?

thanx

nyc212

Report message to a moderator

Re: how to connect lov to push button? [message #322828 is a reply to message #322818]

Mon, 26 May 2008 06:27

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

Senior Member
Account Moderator

Perhaps you didn't push the button hard enough?

Just kidding!

Did you attach LoV to the item? If not, you should. Then create a WHEN-BUTTON-PRESSED trigger which would look like this:

GO_ITEM('this_item');
LIST_VALUES;

Report message to a moderator

Re: how to connect lov to push button? [message #322840 is a reply to message #322818]

Mon, 26 May 2008 07:04

azamkhan
Messages: 557
Registered: August 2005

Senior Member

DECLARE
v_lov BOOLEAN;
BEGIN

v_lov := SHOW_LOV ('lov_name');

END;

Report message to a moderator

Re: how to connect lov to push button? [message #322843 is a reply to message #322828]

Mon, 26 May 2008 07:05

nyc212
Messages: 14
Registered: May 2008

Junior Member

"GO_ITEM('this_item');
LIST_VALUES;"

insted of "this_item" - i am writting the name of the LOV or the item which get the value i chose ?

thanx

nyc212

Report message to a moderator

Re: how to connect lov to push button? [message #322846 is a reply to message #322843]

Mon, 26 May 2008 07:10

nyc212
Messages: 14
Registered: May 2008

Junior Member

when i write
GO_ITEM('this_item');
LIST_VALUES;

and "this_item" is the name of the item which get the value i chose from the lov - when i push the lov's button it does nothing

where should i check ???

nyc212

Report message to a moderator

Re: how to connect lov to push button? [message #322849 is a reply to message #322840]

Mon, 26 May 2008 07:18

nyc212
Messages: 14
Registered: May 2008

Junior Member

thank u azamkhan
it works!!!!!!!!!!!!!
now i need to know how to do that when i chose value from the list its fill a certian filed ???

thanks nyc212

Report message to a moderator

Previous Topic:	Connection not establising ( ORA-12203: TNS:unable to connect to destination) and Forms Installation
Next Topic:	Outer join in ORacle forms 6i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 23:20:28 CST 2025