Home » Developer & Programmer » Forms » how to generate a tree
how to generate a tree [message #277869] Thu, 01 November 2007 00:16 Go to next message
roni_a180
Messages: 45
Registered: October 2007
Member
hi

i create following table

CREATE TABLE MENUGROUPITEM
(
ID NUMBER(19) NOT NULL,
MENUGROUPID NUMBER(19),
MENUCAPTION VARCHAR2(255 BYTE),
PARENTID NUMBER(19),
)

id increametal number,

menugroupid userid (if user id 1 then populate 1 menu group tree , user id 2 then populate 2 menu group tree),



i write a sql

SELECT 1,level,menucaption,0,ID
FROM MENUGROUPITEM
where MENUGROUPID = 3
START WITH PARENTID IS not null
CONNECT BY prior ID = PARENTID

but the parfectly tree is not generate???

anybody help me





Re: how to generate a tree [message #279506 is a reply to message #277869] Thu, 08 November 2007 18:59 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Previous Topic: how to call script inside form!!!
Next Topic: problem in attaching calendar to form 6i
Goto Forum:
  


Current Time: Fri Dec 02 12:10:06 CST 2016

Total time taken to generate the page: 0.11714 seconds