Home » Developer & Programmer » Forms » help me please
help me please [message #306725] Sun, 16 March 2008 05:01 Go to next message
islam175
Messages: 10
Registered: March 2008
Location: Jordan
Junior Member
hello all
im working currently on dev.6i
why when i put this
select 1, level,ename , null, empno from emp
start with ename = 'KING'
connect by prior empno=mgr

not work but when i put
select 1, level,ename , null, to_char(empno) from emp
done well
while in 10g not need to do that ??

how could i create a dynamic hierarchical tree ??
and i put the following
select 1, level,ename , null, empno from emp
start with lower(ename) = lower(test.textitem)
connect by prior empno=mgr

but not work Embarassed Embarassed Embarassed
Re: help me please [message #307194 is a reply to message #306725] Tue, 18 March 2008 02:10 Go to previous messageGo to next message
islam175
Messages: 10
Registered: March 2008
Location: Jordan
Junior Member
please anyone could give me some help
Re: help me please [message #307473 is a reply to message #307194] Tue, 18 March 2008 23:57 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
look at:
Hierarchy Tree
A form with table definition.
http://www.orafaq.com/forum/t/77009/0/unread/67467/#msg_229389
Another form.
http://www.orafaq.com/forum/m/215628/67467/?srch=tree#msg_215628
And another
http://www.orafaq.com/forum/t/83541/67467/
And
http://www.orafaq.com/forum/t/83923/67467/
and from 2005
http://www.orafaq.com/forum/t/32866/67467/
Populate Nth level of Hierarchical tree
http://www.orafaq.com/forum/t/87093/67467/
Icons
http://www.orafaq.com/forum/m/215770/67467/?srch=TRIGGER_NODE#msg_215770
Change the icon on a node.
http://www.orafaq.com/forum/t/90909/67467/
Show Image In Tree
http://www.orafaq.com/forum/t/95682/67467/
FTREE Documentation - Metalink Note:210663.1

David
Re: help me please [message #308462 is a reply to message #306725] Mon, 24 March 2008 07:34 Go to previous messageGo to next message
islam175
Messages: 10
Registered: March 2008
Location: Jordan
Junior Member
Dear Mr.djmartin
thank you for replaying
but sir i wanna put a textitem and Hierarchy Tree on the screen
and when typing a scott - for example - in the textitem populate the tree by scoot root, then when change the scott to king re-populate the tree with king root
so how could i do that ?!!
Re: help me please [message #309077 is a reply to message #306725] Wed, 26 March 2008 06:39 Go to previous message
islam175
Messages: 10
Registered: March 2008
Location: Jordan
Junior Member
HELLO ALL
ACTUALLY I SOLVED MY PROPLEM AND I SEE ITS NICE TO LET YOU SEE IT
WHEN I CREATE A TREE AND IN THE PROPERITY (QUERY DATA) I PUT

SELECT 1, LEVEL,EMAME,NULL,EMPNO.FROM EMP
START WITH UPPER(ENAME)=UPPER(:BLOCKNAMEHASTEXT.TEXTITEM)
CONNECT BY PRIOR EMPNO=MGR

THEN I CREATE A NEW DATA BLOCK HAS A TEXTITEM , AND I USED A WHEN_VALIDATE_ITEM TRIGGER ON TEXTITEM LEVEL TO POPULATE THE TREE

BEGIN
FTREE.POPULATE_TREE(BLOCKNAMEHASTREE.TREE);
END

AND NOW IF YOU TYP IN THE TEXTITEM SCOTT THEN THE ROOT OF THE TREE WILL BE A SCOTT IF KING THE ROOT WILL BE AS A KING...ETC

BEST REGARDS
ISLAM
Previous Topic: Calender
Next Topic: PDF - MAIL
Goto Forum:
  


Current Time: Sat Dec 10 10:37:51 CST 2016

Total time taken to generate the page: 0.04032 seconds