LOV's:Show Lov of Item with pushbutton

Posted on 1998-12-31
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.
Question by:gmoore
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Author Comment

ID: 1083519
Obvousily the code will be in the when-validate-trigger of the pushbutton

Accepted Solution

petwg earned 0 total points
ID: 1083520 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 ....
:blockname.item_with_lov := 'some stupid value';
then it will pop out the LOV... :)



Expert Comment

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.


Author Comment

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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to recover a database from a user managed backup

739 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