Forums Active Threads
Print Thread
order siblings by problem
#9692 01/31/08 02:17 PM
Joined: Nov 2006
Posts: 44
Ukraine
D
Devil Offline OP
Member
OP Offline
Devil
Member
D
Joined: Nov 2006
Posts: 44
Ukraine
When I'm execute hierarchical query

[START WITH condition] CONNECT BY condition

and implement order by clause with siblings:

order siblings by

I get error ora-00936: missing expression.

DOA is support for order siblings by ?
What you think Marco?
Re: order siblings by problem
#9693 01/31/08 04:14 PM
Joined: Aug 1999
Posts: 22,220
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,220
Are you using a TOracleDataSet? If so, can you show me the complete query?

Marco Kalter
Allround Automations
Re: order siblings by problem
#9694 01/31/08 05:41 PM
Joined: Nov 2006
Posts: 44
Ukraine
D
Devil Offline OP
Member
OP Offline
Devil
Member
D
Joined: Nov 2006
Posts: 44
Ukraine
Opps, I'm sorry, It's work fine

Maby I copy not correctly working query text in to Delphi code.

Thanks

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.034s Queries: 13 (0.011s) Memory: 2.5030 MB (Peak: 3.0426 MB) Data Comp: Off Server Time: 2024-05-19 09:34:52 UTC
Valid HTML 5 and Valid CSS