This discussion is archived
3 Replies Latest reply: Jan 8, 2013 4:25 AM by yoonas RSS

OPEN FORM WHEN-TREE-NODE-SELECTED

983455 Newbie
Currently Being Moderated
hello all...
i have a tree and i wanna when i click on the node another forms open due to form name

i have table includes form_if,form_name " as in H.D.D"
when i present all nodes and i click on the node the form opened and when i click on other node from the tree

" the last previous selected node also opened and when i close it the new form is opened and so on"
------------------------------------
the code in when-tree-node-selected is

DECLARE
     
node_value varchar2 (100);
frm_name varchar2 (100);
path varchar2 (100);
     
BEGIN

node_value := ftree.get_tree_node_property('block33.sub_TREE',:SYSTEM.TRIGGER_NODE, FTREE.NODE_VALUE);
select FRM_NAME into frm_name
from forms_list
where FO_ID = node_value
path :=(frm_name||'.fmx');
call_form(path);
path:=null;
frm_name:=null;

EXCEPTION

WHEN NO_DATA_FOUND THEN NULL;

END;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points