Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
Home » Developer & Programmer » Forms » tree in lov
tree in lov [message #318854] Thu, 08 May 2008 04:29 Go to next message
salwa
Messages: 36
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
Report message to a moderator
Re: tree in lov [message #319078 is a reply to message #318854 ] Fri, 09 May 2008 00:14 Go to previous message
djmartin
Messages: 7007
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
What is the problem you are trying to solve?

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

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

[ Syndicate this forum (XML) ] [ ]

Current Time: Thu Jul 24 02:57:19 CDT 2008

Total time taken to generate the page: 0.01816 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.