Home » Developer & Programmer » Forms » tree in lov
tree in lov [message #318854] Thu, 08 May 2008 04:29 Go to next message
salwa
Messages: 76
Registered: December 2007
Member
hi all
how to create tree in LOV


my code is

SELECT -1,level,gldescription||' ('||glmapcode||')',null,glmapcode
FROM GLACCOUNT g
START WITH glid = 2000000
CONNECT BY NOCYCLE prior glID = glPARENTID and GLLEVEL <>0
order siblings by gldescription asc
Re: tree in lov [message #319078 is a reply to message #318854] Fri, 09 May 2008 00:14 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What is the problem you are trying to solve?

You have your 'select' statement. Have you tried creating a 'record_group' using it?

David
Previous Topic: Is LOV updated every time the form runs ?
Next Topic: Sending mails with attachements
Goto Forum:
  


Current Time: Sun Dec 04 16:29:57 CST 2016

Total time taken to generate the page: 0.05876 seconds