OraFAQ Forum: Forms » Get value from table and create pop up menu

Home » Developer & Programmer » Forms » Get value from table and create pop up menu (Oracle Developer Suite 10g,Win 7 Professional 64 bit)

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

Get value from table and create pop up menu [message #642491]

Fri, 11 September 2015 18:22

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Hi All
I appreciate if some one help me out...
I have a button on form layout, my requirement is that When I pressed button then it will show some sort of dynamic pop up menu that will get all menu values from one of my table.
In addition, if we click any menu item then it will call specific report..
For example

If we consider the example of emp and dept then if I will press button then system will go to dept table and get all deptno from there and show those deptno as menu item and if I click deptno 30 then it will call one of my report that is related to deptno 30...

I don't know whether is it possible in oracle form or not....

Thanks and Regards

Report message to a moderator

Re: Get value from table and create pop up menu [message #642665 is a reply to message #642491]

Wed, 16 September 2015 14:14

bluetooth420
Messages: 146
Registered: November 2011

Senior Member

I think you need to us LOV

Below button use when button pressed trigger and use "show_lov"

Report message to a moderator

Re: Get value from table and create pop up menu [message #642711 is a reply to message #642665]

Thu, 17 September 2015 09:07

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

Quote:

If we consider the example of emp and dept then if I will press button then system will go to dept table and get all deptno from there and show those deptno as menu item and if I click deptno 30 then it will call one of my report that is related to deptno 30...

Please clarify what you mean when you say "Menu" as this is confusing.

What you want to do, Click a button, display some values and perform and action depending on the which value is selected, is pretty standard actions. It seems to me that your When-Button-Pressed (WBP) trigger just needs to show a canvas that lists the values from your table. Then, in your list of items, have a When-Mouse-Click (WMC) or When-Mouse-Doubleclick (WMD) trigger that reads the value of the selected row and takes an action based on that value. You can design your "Canvas" to look like a Context-Menu (Popup menu).

Report message to a moderator

Re: Get value from table and create pop up menu [message #642735 is a reply to message #642711]

Thu, 17 September 2015 11:15

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Hi Craig
Thanks for reply , let me tell you my requirement in details.
I have a table in which all roles are defined and against those roles specific reports names attached...Now what I want is that When user Pressed some sort of Push button then it will get all reports name associated with that role and show List of value or pop up menu, if user selected any value from pop up or LOV then oracle forms call that specific report...

Please let me know if you need more details..

Regards
Muzz

Report message to a moderator

Re: Get value from table and create pop up menu [message #642844 is a reply to message #642735]

Mon, 21 September 2015 09:34

CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA

Senior Member

This is what I thought you where trying to accomplish. This can easily be done by simply creating a new Data Block, Canvas and Window to display your list of available reports for the user.

Quote:

I have a table in which all roles are defined and against those roles specific reports names attached.

Add a new data block to your form based on this table. Then filter the table for the specific user using the WHERE Clause property of the block.

Quote:

Now what I want is that When user Pressed some sort of Push button then it will get all reports name associated with that role and show List of value or pop up menu

The code in your When-Button-Pressed trigger will simply send the navigation cursor to the First Item in your new block using GO_ITEM('BLOCK.ITEM_NAME'). Now, write a When-Mouse-Doubleclick trigger that will execute the selected report or have the user click on the desired report and then click on a "Run Report" button. Either way, the result is the same. Smile

Craig...

Report message to a moderator

Re: Get value from table and create pop up menu [message #642858 is a reply to message #642844]

Mon, 21 September 2015 23:10

shumail
Messages: 149
Registered: September 2012
Location: Canada

Senior Member

Thanks for the reply Craig, I really appreciate your help....

Report message to a moderator

Previous Topic:	FORMS AND REPORTS 11G
Next Topic:	forms (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 17:33:23 CST 2025