Hello all,
From here i got the folowing code,it helps me to retrieve the whole record which is related to the selected node in
WHEN-TREE-NODE-SELECTED Trigger :
------------------------------------------------------
declare
rank number := 0;
begin
rank :=
ftree.get_tree_node_property('TREE_BLOCK_TEST.TREE13',
:system.trigger_node, ftree.node_depth);
if rank >= 1 then
GO_BLOCK ('INSP_EQUIPMENT_TYPE');
set_block_property ('INSP_EQUIPMENT_TYPE', default_where,
'EQUIPMENT_TYPE_D='||ftree.get_tree_node_property('TREE_BLOCK_TEST.TREE13',
:system.trigger_node, ftree.node_value));
Execute_Query(No_ValiDATE);
end if;
end;
What i want to do is to retieve not only the current record for the selected node but aslo the related childern in the tree to this node.
Could anyboady help me pls. ?!
Regards,
Abdetu..