Email Us : sunilkumark11@gmail.com
Free Training > SQL PL / SQL Forms Reports Oracle Applications
< Previous Next >

 
Forms - Menus

Menus are list of items then end users use to select specific functions or operations.
Menus are saved with extension .mmb
.mmx file is created when we compile .mmb file.

Example
Open the form builder tool Create new Menu.
Go to the property palette, name it as MY_MENU

Go to Tools Menu Editor
Using  add buttons , add menu items towards down and right.
Provide appropriate labels.

Provide code for the menu items.

Select Save Go to its PL/SQL editor,   provide the following code and compile.

Similarly, select Exit Go to its PL/SQL editor   provide the following code and compile.

exit_form;

Select  cut   Go to its property palette provide the following details
Functional
Menu Item Type Magic
Magic Item Cut

Select  copy   Go to its property palette provide the following details
Functional
Menu Item Type Magic
Magic Item Copy

Select  Paste   Go to its property palette provide the following details
Functional
Menu Item Type Magic

Magic Item Paste

Save the menu.
Go to File Save as MY_MENU.mmb

Compile the menu
Go to  Program Compile Module
Observe  MY_MENU.mmx file as generated.

Now, create a new table EMPSEVEN in the database ( same as standard EMP table )

Create new form based on EMPSEVEN table using Data block wizard and layout wizard.
Save the form with the name EMP_SEVEN.fmb

Attach menu ( MY_MENU)  to the form ( EMP_SEVEN )
Go to the property palette of the form
Functional
Menu Module MY_MENU    ( Replace DEFAULT&SMARTBAR )

Not just mentioning the Menu in Menu Module property,
we need to place MY_MENU.mmb and MY_MENU.mmx file in FORMS_PATH directory ( In the server).

Get the FORMS_PATH  directory information in default.env file.
Assume in window environment FORMS_PATH  is  set  to   C:\DevSuiteHome_1\forms

Copy MY_MENU.mmb and MY_MENU.mmx file in  C:\DevSuiteHome_1\forms

Save EMP_SEVEN.fmb
Compile the form.
Run the form.

Observer instead of default menu, we are able to get our menu.

Popup menu
Popup menus are attached to individual items or canvas.
Example
Create a form based on EMPSEVEN table using data block wizard and layout wizard.
Save the form with extension EMP_POP.fmb

Under EMP_POP select Popup Menus create an new menu
In the property palette name it as M1

Select M1 , Go to Tools Menu Editor

Create Menu Items Cut, Copy , Paste and Clear using add button ( down ).

Select menu item Cut Property palette
Functional
Menu Item Type Magic
Magic Item Cut

Similarly
Select menu item Copy Property palette
Functional
Menu Item Type Magic
Magic Item Copy

Select menu item Paste Property palette
Functional
Menu Item Type Magic
Magic Item Paste

Select menu item Clear Property palette
Functional
Menu Item Type Magic                                                                                                                         
Magic Item Clear

Now, Assign the Popup menu ( M1) to the Item ( JOB)

Select text item JOB Property palette
Functional
Popup Menu M1

File Save
Compile the form
Run the form

Now, right click on JOB, you can see the Popup menu.

 


< Previous Next >