.What i want to do is to create a tree to view each client with all contracts belongs to him

the tables im using are Clients and Contracts

Clients Table : Client_id,Client_name

Contracts Table: contract_id.Client_id,Contract_title

?Is there anyway to do that
.Looking forward to hearing from you
P.S: IM using oracle 10g

تم تعديل 1 ديسمبر 201015 سنة بواسطة ENG.Ahmed G.Shahbo

good evening sir
all you need to create your tree
just create new block and add hierarchical tree

add this code in when-new-form-instance

declare
a_node ftree.node;
b_node ftree.node;
htree item;
begin
htree := find_item('tree name');

for i in (select * from Clients ) loop

a_node :=ftree.add_tree_node((htree, Ftree.ROOT_NODE, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  i.Client_name,  NULL, i.clint_id);
for j in(select * from Contracts where contract_id.Client_id=i.clint_id) loop
b_node :=ftree.add_tree_node((htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  j.Contract_title,  NULL, j.contract_id);
end loop;
end loop;
end;

,Dear Sir
.Did you try to compile that code, Because each time i try to compile it it gives me Error with the ';' Can you please check it and update me

Thanks and Regards

good evening sir
all you need to create your tree
just create new block and add hierarchical tree

add this code in when-new-form-instance

declare
a_node ftree.node;
b_node ftree.node;
htree item;
begin
htree := find_item('tree name');

for i in (select * from Clients ) loop


a_node :=ftree.add_tree_node((htree, Ftree.ROOT_NODE, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  i.Client_name,  NULL, i.clint_id);
for j in(select * from Contracts where contract_id.Client_id=i.clint_id) loop
b_node :=ftree.add_tree_node((htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  j.Contract_title,  NULL, j.contract_id);
end loop;
end loop;
end;

ok try this
assume that you have a hierarchical tree call it "tree7" ok
now in trigger when-new-form-instance or anywhere
type this code and check the column name in code

declare
a_node ftree.node;
b_node ftree.node;
htree item;
begin
htree := find_item('tree7');

for i in (select * from Clients ) loop

a_node :=ftree.add_tree_node(htree, Ftree.ROOT_NODE, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  i.Client_name,  NULL, i.clint_id);

for j in(select * from Contracts where Client_id=i.clint_id) loop

b_node :=ftree.add_tree_node(htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  j.Contract_title,  NULL, j.contract_id);

end loop;

end loop;

end;

EX. on hr schema

تم تعديل 1 ديسمبر 201015 سنة بواسطة HELL-BOY

Thanks So Much for your support and care , i did fixed the code from the first time and its working propaply now .. but can i ask for something more if you dont mind

I need the color of the node to be changed when one condition happen. Like when its the time for the renewal date of the contract , i want the color of the node for that client name to be changed to different color .. like RED, So the user can notice it and send him an E-mail with the renewal date .
? Is it possible

ok try this
assume that you have a hierarchical tree call it "tree7" ok
now in trigger when-new-form-instance or anywhere
type this code and check the column name in code

declare
a_node ftree.node;
b_node ftree.node;
htree item;
begin
htree := find_item('tree7');

for i in (select * from Clients ) loop

a_node :=ftree.add_tree_node(htree, Ftree.ROOT_NODE, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  i.Client_name,  NULL, i.clint_id);

for j in(select * from Contracts where Client_id=i.clint_id) loop

b_node :=ftree.add_tree_node(htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD, Ftree.EXPANDED_NODE,  j.Contract_title,  NULL, j.contract_id);

end loop;

end loop;

end;

EX. on hr schema

i think there is no any way to change the node color in run time
but we can change the node icon by using if condition
ex

if contract_date between any_date and any_date then 
b_node :=ftree.add_tree_node
(htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,
 j.Contract_title,  'your icon here', j.contract_id);

else
b_node :=ftree.add_tree_node(
htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,  j.Contract_title,  
'your another icon here', j.contract_id);

end if;

i hope this is help you

تم تعديل 7 ديسمبر 201015 سنة بواسطة HELL-BOY

.Thanks for the idea but the icons didnt show with me . i think something is wrong
Can you please make a sample tree with this option and send it to me .. i also think that some settings need to be changed to make me able to see the icons during the run time.
? can u please tell me how to do that

Also cant we make another option instead of the icon option .. when the condition happen the color of the contract title name that shows in the node change into another color .. Is that possible
.Lookng forward to hearing from you

Ahmed.

i think there is no any way to change the node color in run time
but we can change the node icon by using if condition
ex

if contract_date between any_date and any_date then 
b_node :=ftree.add_tree_node
(htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,
 j.Contract_title,  'your icon here', j.contract_id);

else
b_node :=ftree.add_tree_node(
htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,  j.Contract_title,  
'your another icon here', j.contract_id);

end if;

i hope this is help you

تم تعديل 8 ديسمبر 201015 سنة بواسطة ENG.Ahmed G.Shahbo

,,,,,,,,,,,,,

I Created an icon file and i can see the icon when i add it on any button . but i cant see the icon on the tree .. can you please tell me what is the problem?

i think there is no any way to change the node color in run time
but we can change the node icon by using if condition
ex

if contract_date between any_date and any_date then 
b_node :=ftree.add_tree_node
(htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,
 j.Contract_title,  'your icon here', j.contract_id);

else
b_node :=ftree.add_tree_node(
htree,a_node, Ftree.PARENT_OFFSET, Ftree.LAST_CHILD,
Ftree.EXPANDED_NODE,  j.Contract_title,  
'your another icon here', j.contract_id);

end if;

i hope this is help you

i have recorded the method to create iconic tree
you can download it from here

http://www.mediafire.com/?tn33th6i8cn7omt

تم تعديل 9 ديسمبر 201015 سنة بواسطة HELL-BOY

Thanks Brother .. i will download and check it now .. I really appreciate your effrots to help me. I will keep you updated with the results
Once Again Thanks

i have recorded the method to create iconic tree
you can download it from here

http://www.mediafire.com/?tn33th6i8cn7omt

!! The file is corrupted
?Can you try another way to send me the file please
Thanks

i have recorded the method to create iconic tree
you can download it from here

http://www.mediafire.com/?tn33th6i8cn7omt

aaa.bmp

try this link
http://www.multiupload.com/S8IO61FV1V

Thanks i got the file Oracle.MP4
BUt its not working with normal windows media player , i will download another media player to check it . and Update you .
Thanks Again

try this link
http://www.multiupload.com/S8IO61FV1V

!!!I downloaded Winamp and Real Player but still not working .. only playing on real playing but wihtout video screen
!!IS there any other ways to send me the way to create iconic Tree.. Like Word File with steps to follow
or tell me the name of the media player that u r using and i will download it . otherwise the file maybe corrupted and thats why its not working ont the media players im downloading.

Waiting for your reply .

Thanks Waleed , I saw the video and i try ur way asap.
will keep you updated with the results .. bas ISA it will work

!!!I downloaded Winamp and Real Player but still not working .. only playing on real playing but wihtout video screen
!!IS there any other ways to send me the way to create iconic Tree.. Like Word File with steps to follow
or tell me the name of the media player that u r using and i will download it . otherwise the file maybe corrupted and thats why its not working ont the media players im downloading.

Waiting for your reply .

انا مش عارف اشوف التريجر بيظهر عندى (encoded program unit has unknown format)

وجزاكم الله خير على المجهود