Home » Developer & Programmer » Forms » Tree Problem (oracle 10g, forms 6i, windows)
Tree Problem [message #509303] Fri, 27 May 2011 01:48 Go to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
I created TREE object in my application main menu and I want to use it through MOUSE and KEYBOARD therefore I add WHEN-TREE-NODE-ACTIVATED trigger at my tree object

Trigger text is:
declare
	htree item;
	node_value VARCHAR2(100);
	akt_node ftree.node;
	pl_id        PARAMLIST; 
begin
	htree := find_item('TREE_BLOCK.FILE_NAME');
	akt_node := ftree.get_tree_selection(htree, 1);
	node_value := ftree.get_tree_node_property (htree, akt_node, ftree.node_value);

  pl_id := get_parameter_list('mylist');
  If not Id_null(pl_id) Then
     Destroy_parameter_list('mylist');
  End If;
  pl_id := Create_parameter_list('mylist');
	--message(:ptype||' - '||node_value);message(:ptype||' - '||node_value);
	BEGIN
		SELECT CS_TYPE
			INTO :PTYPE
		 FROM COMM_SCREENS
		 	WHERE LTRIM(RTRIM(CS_FILE_NAME)) = LTRIM(RTRIM(NODE_VALUE));

		 	IF :PTYPE = 'F' THEN
			 	ADD_PARAMETER(PL_ID,'P_USERID', TEXT_PARAMETER,:USER_ID);
			 	ADD_PARAMETER(PL_ID,'P_SCREENID', TEXT_PARAMETER, NODE_VALUE);
			 	ADD_PARAMETER(PL_ID,'P_COMPC', TEXT_PARAMETER,:COMPC);
			 	ADD_PARAMETER(PL_ID,'P_BRANC', TEXT_PARAMETER,:BRANC);
			 	ADD_PARAMETER(PL_ID,'P_SEASON', TEXT_PARAMETER,:SEASON);
				ADD_PARAMETER(PL_ID,'P_SESSION', TEXT_PARAMETER,:SESSION);		 	
			 	CALL_FORM(NODE_VALUE,NO_HIDE,DO_REPLACE,NO_QUERY_ONLY,SHARE_LIBRARY_DATA,PL_ID);
			ELSIF :PTYPE = 'R' THEN
			 	ADD_PARAMETER(PL_ID,'P_USERID', TEXT_PARAMETER,:USER_ID);
			 	ADD_PARAMETER(PL_ID,'P_COMPC', TEXT_PARAMETER,:COMPC);
			 	ADD_PARAMETER(PL_ID,'P_BRANC', TEXT_PARAMETER,:BRANC);
			 	ADD_PARAMETER(PL_ID,'P_SEASON', TEXT_PARAMETER,:SEASON);
				Run_Product(REPORTS,NODE_VALUE,ASYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id, NULL);
			ELSIF :PTYPE = 'M' THEN
				NULL;
			ELSE
				NULL;
			END IF;
			--:ptype := null;
	EXCEPTION
		WHEN OTHERS THEN
		NULL;
	END;
EXCEPTION
	WHEN OTHERS THEN
	MESSAGE(SQLERRM);MESSAGE(SQLERRM);
end;


Problem:
When I am using MOUSE and clicking on + or anyother form/report, it's opened last selected form/report or application closed but it is working fine when I am using KEYBOARD.

Furthermore, I want to move pointer at first node whenever menu populate.

[Updated on: Fri, 27 May 2011 02:15]

Report message to a moderator

Re: Tree Problem [message #510446 is a reply to message #509303] Mon, 06 June 2011 01:49 Go to previous message
sairakhushi
Messages: 5
Registered: May 2011
Location: Pakistan
Junior Member

Hello!
I think you should change your trigger from WHEN-TREE-NODE-ACTIVATED to WHEN-TREE-NODE-SELECTED. This will solve your problem. You can navigate through mouse and keyboard.

Thanks!
Saira.
Previous Topic: Opening a form in a Particular Tab
Next Topic: ORA-02291
Goto Forum:
  


Current Time: Thu Sep 12 09:00:18 CDT 2024