hierarchical tree Problem [message #401761] |
Wed, 06 May 2009 06:38 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Dear All
I Create a hierarchical tree on my form my record group query is
SELECT 1, LEVEL, item_Name,'',to_char(item_no) FROM ITEM2 CONNECT BY PRIOR item_no = CATAGORY_NO START WITH item_no in (1,2,3,4,5,6,7,8,9,10)
and My program unit query is
PROCEDURE p_populate_menu IS
tree4 ITEM;
my_tree Number;
BEGIN
tree4 := Find_Item('block2.tree4');
my_tree := POPULATE_GROUP('tree_rg');
Ftree.Set_Tree_Property(tree4, Ftree.RECORD_GROUP, 'TREE_RG');
END;
On when new form instrance
begin
p_populate_menu;
end;
The tree populate working fine but i need item_name and also item_no in this tree
The picture give you more idea about what i need
|
|
|
|
Re: hierarchical tree Problem [message #403198 is a reply to message #401761] |
Thu, 14 May 2009 02:58 |
expertsudhir
Messages: 26 Registered: October 2008 Location: Delhi, India
|
Junior Member |
|
|
concatenate the values in display part i.e. 3rd part, it will show.
SELECT 1, LEVEL, item_Name||'('||to_char(item_no)||')','',to_char(item_no)
FROM ITEM2
CONNECT BY PRIOR item_no = CATAGORY_NO
START WITH item_no in (1,2,3,4,5,6,7,8,9,10)
try it and confirm.
[EDITED by LF: removed unnecessary quote of the whole OP's message. Applied [code] tags]
[Updated on: Thu, 14 May 2009 04:33] by Moderator Report message to a moderator
|
|
|
Re: hierarchical tree Problem [message #403347 is a reply to message #401761] |
Thu, 14 May 2009 23:38 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Thanks a lot Sudhir
its work thanks a lot
well now i need when i right click the hierarchical tree its give me option edit,delete,new and when we click delete its delete the record from hierarchical tree and also from database
its is possible
Thanks & Regards
Shahzaib ismail
|
|
|
|
|
|
Re: hierarchical tree Problem [message #403370 is a reply to message #401761] |
Fri, 15 May 2009 02:54 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
WHEN I USER ORDER BY CLAUSE
SELECT 1, LEVEL, item_Name||' ('||to_char(item_no)||') ','',to_char(item_no)
FROM ITEM2
CONNECT BY PRIOR item_no = CATAGORY_NO
START WITH item_no in (1,2,3,4,5,6,7,8,9,10)
ORDER BY ITEM_NO
ITS GIVE ME RESULT LIKE THIS
GENERAL ITEM (1)
SPARE PARTS (2)
NEEDLE (3)
CLIPPER (1001)
TAG PIN (1002)
FOLDER (2001)
MIX SPARE (2002)
DB*1 # 18 (3001)
DB*1 # 19 (3002)
WHY ITS NOT SORTING LIKE THIS
GENERAL ITEM (1)
CLIPPER (1001)
TAG PIN (1002)
SPARE PARTS (2)
FOLDER (2001)
MIX SPARE (2002)
NEEDLE (3)
DB*1 # 18 (3001)
DB*1 # 19 (3002)
REGARDS
SHAHZAIB ISMAIL
|
|
|
Re: hierarchical tree Problem [message #403378 is a reply to message #401761] |
Fri, 15 May 2009 04:27 |
shahzaib_4vip@hotmail.com
Messages: 410 Registered: December 2008 Location: karachi
|
Senior Member |
|
|
Thanks Sudhir
you told me
Create popup menu and add it in property of hierarchical tree.
write code on the menu items.
i make popup menu with report now i need to show my report when i right click and click of report and
my report also contain with one parameter which is item_no so what will i write in pl/sql of report ?
for example i need stock report only for the selected item_no of tree
Hope you understand
Regards
Shahzaib ismail
|
|
|