Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Question

Status
Not open for further replies.
MaeJams

MaeJams

Programmer
Apr 24, 2001
51
US
I have an Oracle SQL statement running through a VB DLL. The Oracle SQL runs fine when running in a SQL tool, but when attempting to run through ADO in the VB DLL, the ORDER BY clause does not seem to function. The records are returned fine, but the records are not ordered as specified in the ORDER BY clause. This SQL statement involves the use of a MINUS keyword...

SELECT statement 1
MINUS
(SELECT statement 2)
ORDER BY
Field1

If anyone has any advice to offer, I would greatly appreciate it.

Thanks,
Rich
 
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
DRAG AND DROP question. 1
Replies
5
Views
156
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Adobe SDK
Replies
6
Views
134
Swi
Swi
strongm
  • Locked
  • Question
Where did the question about MSFlexgrid go?
Replies
2
Views
111
strongm
strongm
eHaviv
  • Locked
  • Question
Vb.net question
Replies
12
Views
200
eHaviv
eHaviv
2009luca
  • Locked
  • Question
2 question about SCHTASKS 1
Replies
3
Views
91
2009luca
2009luca

Part and Inventory Search

Sponsor

Back
Top