Home » Developer & Programmer » Forms » Find_menu_item (Forms 6i)
Find_menu_item [message #312229] Tue, 08 April 2008 04:40 Go to next message
dillango
Messages: 145
Registered: January 2008
Senior Member
Hi,

How to check the output of "Find_menu_item"?

my code is like this.
declare
mid menuitem;
menunm varchar2(40);
begin
menunm := 'MASTERS_MENU.USER_MASTER';
mid := find_menu_item(menunm);
---How to check here?
if exist....

SET_MENU_ITEM_PROPERTY(MID,ENABLED,PROPERTY_FALSE);
end if;
end;


Please have your views.

Ilango
Re: Find_menu_item [message #312427 is a reply to message #312229] Tue, 08 April 2008 19:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please read the reference manual entry for 'FIND_MENU_ITEM' or the online help entry for 'FIND_MENU_ITEM'. They both have a fully worked example of how to use the command'

David
Re: Find_menu_item [message #439149 is a reply to message #312229] Thu, 14 January 2010 12:01 Go to previous messageGo to next message
mayquant
Messages: 3
Registered: January 2010
Location: Nicaragua
Junior Member

can you help whith this error, i don`t understand why this code is wrong.

procedure enable_disable_query_items is
mi_id MenuItem;
begin

mi_id := find_menu_item('BCN_PANTALLAS.LAST_CRITERIA');
Set_Menu_Item_Property(mi_id,ENABLED,PROPERTY_TRUE);
end;
when i compiled appear the error-41067, and in mi_id don`t save the valor of this variable.

thanks!

sorry my english is really bad Confused
Re: Find_menu_item [message #439158 is a reply to message #439149] Thu, 14 January 2010 12:39 Go to previous messageGo to next message
Littlefoot
Messages: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
FRM-41067: Cannot find Menu Item: invalid ID.
Cause: An invalid ID was passed to a built-in subprogram.

Action: Verify that a proper call to FIND_MENU_ITEM will be performed. Level: 20 Type: Error


Is there that menu item (BCN_PANTALLAS.LAST_CRITERIA), anyway? Perhaps you could check it as
DECLARE
  mi_id MENUITEM;
BEGIN
  mi_id := FIND_MENU_ITEM('BCN_PANTALLAS.LAST_CRITERIA');
  IF NOT ID_NULL(mi_id) THEN
     -- OK, it exists. Now do something
     your_code_here;
  END IF;
END;
Re: Find_menu_item [message #439168 is a reply to message #439158] Thu, 14 January 2010 14:14 Go to previous messageGo to next message
mayquant
Messages: 3
Registered: January 2010
Location: Nicaragua
Junior Member

Thanks for reply,
the item last_criteria exists but i don`t know how i can to call it, i donĀ“t know if the item_name bcn_pantallas.last_criteria is correct.

i attach an image of my form for give you a idea. thanks
  • Attachment: forma.JPG
    (Size: 48.83KB, Downloaded 340 times)
Re: Find_menu_item [message #439175 is a reply to message #439168] Thu, 14 January 2010 15:02 Go to previous message
mayquant
Messages: 3
Registered: January 2010
Location: Nicaragua
Junior Member

THANKS, i found the problem i named the form incorrectly... Razz
Previous Topic: Refresh Data in Detail Block
Next Topic: Insert data 2 tables at a time through Form 6i
Goto Forum:
  


Current Time: Fri Sep 30 17:27:58 CDT 2016

Total time taken to generate the page: 0.30725 seconds