| help me please [message #306725] |
Sun, 16 March 2008 05:01  |
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 
|
|
|
|
|
|
|
|
| Re: help me please [message #308462 is a reply to message #306725] |
Mon, 24 March 2008 07:34  |
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 |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
