Home » Developer & Programmer » Forms » Menu Problem (Froms6i)
Menu Problem [message #410743] Tue, 30 June 2009 01:29 Go to next message
Messages: 266
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.
Cursor c is 
Select A.Mnu_Itm_Nam
From A,B
Where A.Itm_ide=B.Itm_Ide;
For V In C Loop
End Loop;

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
Messages: 10180
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.

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

Current Time: Fri Jul 28 12:16:10 CDT 2017

Total time taken to generate the page: 0.12924 seconds