Home » Developer & Programmer » Forms » Menu Tree (DS 10g, Win XP)
Menu Tree [message #443128] Fri, 12 February 2010 21:09 Go to next message
rkgoyal98
Messages: 39
Registered: October 2009
Member

Hello,

I have a form in which menu tree is populated with this sql
SELECT 1, Level, MenuLabel, MenuName, MenuId
FROM MenuFile
CONNECT BY PRIOR MenuId = ParentId START WITH menuId = :moduleid||'0000'

The result is attached in the CSV file enclosed in sheet mrnufile1
As we can see in row 3 the item LPC has menuid BDME13.
In my view This item should be in ROW 19.
How can i change query do get the desired the result.
I have also tried another sql query.
select * from menufile where applicationid = 'BD' order by parentid,menuid

Result of this query is in 2nd Half of CSV file
Kindly help me to sort out this
Regards
  • Attachment: Menu.csv
    (Size: 4.34KB, Downloaded 182 times)

[Updated on: Fri, 12 February 2010 21:20]

Report message to a moderator

Re: Menu Tree [message #443138 is a reply to message #443128] Sat, 13 February 2010 00:06 Go to previous messageGo to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
Dear,

Give me your menufile table script & some sample data with insert into command not csv file.

Regrads,

Tamzidul Amin.
Re: Menu Tree [message #443201 is a reply to message #443128] Sat, 13 February 2010 10:55 Go to previous message
rkgoyal98
Messages: 39
Registered: October 2009
Member

Hello,

Kindly look into my another query in the run_report_object Topic.

http://www.orafaq.com/forum/t/153108/0/unread/145801/
i am enclosing there with table script and insert into command also
Regards
  • Attachment: MENUFILE.TXT
    (Size: 26.52KB, Downloaded 251 times)
Previous Topic: Dynamically value (get roles) in combo box
Next Topic: check global variable
Goto Forum:
  


Current Time: Fri Dec 09 15:15:13 CST 2016

Total time taken to generate the page: 0.22806 seconds