3 Replies Latest reply: Jan 8, 2013 6:25 AM by yoonas RSS

    OPEN FORM WHEN-TREE-NODE-SELECTED

    983455
      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;