Home » Developer & Programmer » Forms » Menu Problem (Froms6i)
Menu Problem [message #410743] Tue, 30 June 2009 01:29 Go to next message
mamalik
Messages: 270
Registered: November 2008
Location: Pakistan
Senior Member

Aslam-O-Alaikum Dear All.

I have created a menu using forms 6i. I am controlling menu item rights through db table. Problem is that i have created a table A with follwoing structure.
Mnu_Itm_Ide,       Mnu_Itm_Nam,      Itm_Ttl
          1       Fsd_Mnu.Man_Frm   Main Form
          2       Fsd_Mnu.Sub_Frm   Sub Form
       


Another Tsble B is

 Usr_cod,  Itm_Ide
          1       1
          1       2


and follwoing code on when-new-form-instanance trigger.
Declare
Cursor c is 
Select A.Mnu_Itm_Nam
From A,B
Where A.Itm_ide=B.Itm_Ide;
Begin
For V In C Loop
	SET_MENU_ITEM_PROPERTY(V.MNU_ITM_NAM,VISIBLE,PROPERTY_TRUE);
	SET_MENU_ITEM_PROPERTY(V.MNU_ITM_NAM,Label,v.itm_des);
End Loop;
End;

It is running well. but some time when menu item is clicked main form is terminated. Some times there are a lot separtor lines in menu and no item in menu.

How can i solve this.

Thanks In Advance.

Muhammad Asif Malik
Re: Menu Problem [message #410876 is a reply to message #410743] Tue, 30 June 2009 20:04 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
You have 'Itm_Ttl' in the table description and 'v.itm_des' in the cursor.

Be lazy!! Copy and paste a 'desc' of the table. Don't key it from memory.

David
Previous Topic: Database column in a non-database block
Next Topic: First query - all searchable
Goto Forum:
  


Current Time: Mon Feb 10 04:13:14 CST 2025