Home » Developer & Programmer » Forms » when - tree - node -select
when - tree - node -select [message #277759] Wed, 31 October 2007 07:03 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
i write following code,when the node select the selected form is open.

but my problem is when i select the node then the particular form is open , but then i change the node first time open the previous selected node form then open present selected node form

pls anybody help me????????


DECLARE
   NODE_VALUE    VARCHAR2(20);
   v_showalert   NUMBER;
   htree         ITEM;
   v_id          NUMBER;
   v_call        VARCHAR2(500);
BEGIN
   v_id           := '';
   NODE_VALUE     := '';
   v_call         := '';
   htree          := FIND_ITEM('BLOCK17.T_POP');
   NODE_VALUE     :=
      FTREE.GET_TREE_NODE_PROPERTY('BLOCK17.T_POP'
                                 , :SYSTEM.TRIGGER_NODE
                                 , FTREE.NODE_LABEL
                                  );
   v_showalert    := showalert(NODE_VALUE, 1);
   v_call         := '';

   SELECT DISTINCT MENUACTIONID
   INTO            v_id
   FROM            MENUGROUPITEM
   WHERE           LTRIM(RTRIM(MENUCAPTION)) = LTRIM(RTRIM(NODE_VALUE));

   SELECT ACTIONCLASS
   INTO   v_call
   FROM   MENUACTION
   WHERE  ID = v_id;

   CALL_FORM(v_call);
EXCEPTION
   WHEN OTHERS
   THEN
      NULL;
END;


[mod-edit]applied code tags.

[Updated on: Wed, 31 October 2007 08:02] by Moderator

Report message to a moderator

Re: when - tree - node -select [message #277873 is a reply to message #277759] Thu, 01 November 2007 00:40 Go to previous message
sandeep.kushwaha
Messages: 10
Registered: October 2007
Location: India
Junior Member

When-Tree-Node-Selected Trigger Fires when a node is selected or deselected.
Previous Topic: ORA-03113 AND ora-03114
Next Topic: Creating user usnig forms_DDL
Goto Forum:
  


Current Time: Sun Dec 04 16:46:28 CST 2016

Total time taken to generate the page: 0.12610 seconds