Re: Best Way to Create Menus

huynh_at_condor.navsses.navy.mil wrote:

: Hi All,
 

: The project I am working on requires many menus. Should I do this using
: SQL*Menu or just do it through SQL*Forms. Which way is more efficient?
: And which way is easier to maintain?

If you haven't bought SQL*MENU yet, then just use FORMS. You can make real nice looking MENUS...sometimes with even more functionality that what you get out of SQL*MENU.

For example, You can create scrolling menus that appear as a popup box in the middle of your screen(overlapping over data entry screens).

You can also put your menu items with corresponding actions into Oracle Tables. This way, when you need to update your menu, you just add an item to the oracle table, and the menu dynamically grows. With SQL*MENU, you would have to go into the menu designer, add the item, Save the Menu and generate it. Then make sure all your users are using the right(new) dmm file.

On the other hand, SQL*MENU provides a way to implement pull down menus, which you could not do the forms directly. YOu can also do the bar style menus( like in older DOS apps).

SQL*MENU also has an entire ROLE based system of allowing specific users into certain parts of your menu. Oh..by the way, you can set up hierachical menu systems with SQL*MENU. That kind of thing would take a bit of programming under FOrms.

Good luck!

-- 
------------------------------------------------------------------
Steve Schow    | But you don't have to use the claw, if you
sjs_at_netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear
------------------------------------------------------------------