Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

LOV's:Show Lov of Item with pushbutton

Posted on 1998-12-31
4
Medium Priority
?
1,674 Views
Last Modified: 2012-06-22
I want to show lov of current item with pushbutton on toolbar. Or be able to execute the F9 key to show lov of current item from pushbutton.
0
Comment
Question by:gmoore
  • 2
4 Comments
 

Author Comment

by:gmoore
ID: 1083519
Obvousily the code will be in the when-validate-trigger of the pushbutton
0
 
LVL 1

Accepted Solution

by:
petwg earned 0 total points
ID: 1083520
my....my..... what a nice 3 points......
what the heck....
I think I did do it once.... by using the when button push... and use go_item('item_with_lov')

make the LOV display automatically on click.... or you can set it to check for LOV and put like ....
go_item('item_with_lov')
:blockname.item_with_lov := 'some stupid value';
then it will pop out the LOV... :)

petwg

0
 
LVL 3

Expert Comment

by:vlad_impala
ID: 1083521
In clear stages....

Set the mouse navigate property of the button on the toolbar to false (to stop focus moving to the button when you click it).
Create a WHEN-BUTTON-PRESSED trigger on the button, in the trigger put DO_KEY('LIST_VALUES'); - this will display whatever LOV is associated with the item focus was in when the button was pressed.

Vlad.
0
 

Author Comment

by:gmoore
ID: 1083522
I used Vlad answer, it was cleaner and easier for me. Although Petwg answer works too.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question