Home » Developer & Programmer » Forms » how to connect lov to push button?
how to connect lov to push button? [message #322818] Mon, 26 May 2008 05:42 Go to next message
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
Re: how to connect lov to push button? [message #322828 is a reply to message #322818] Mon, 26 May 2008 06:27 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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;
Re: how to connect lov to push button? [message #322840 is a reply to message #322818] Mon, 26 May 2008 07:04 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
DECLARE
v_lov BOOLEAN;
BEGIN

v_lov := SHOW_LOV ('lov_name');

END;
Re: how to connect lov to push button? [message #322843 is a reply to message #322828] Mon, 26 May 2008 07:05 Go to previous messageGo to next message
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
Re: how to connect lov to push button? [message #322846 is a reply to message #322843] Mon, 26 May 2008 07:10 Go to previous messageGo to next message
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
Re: how to connect lov to push button? [message #322849 is a reply to message #322840] Mon, 26 May 2008 07:18 Go to previous message
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
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:
  


Current Time: Sat Dec 03 03:46:17 CST 2016

Total time taken to generate the page: 0.11110 seconds