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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multuiple resultset in ADO problem

Status
Not open for further replies.
martinm

martinm

IS-IT--Management
Mar 30, 2001
113
GB
Hi all. Running some SQL through a TADODataSet that returns multuple resultsets works fine using TADODataSet.NextRecordSet.

However, when the SQL has (as in this case) a truncate #tmp or delete #tmp between resultsets, only one rs gets returned.
set nocount on doesn't help.

No parameters have been added.

Any ideas?
 
Status
Not open for further replies.

Similar threads

sysmatics
  • Locked
  • Question
how to add an image on the selected field in a dbgrid in Delphi 7
Replies
2
Views
513
emailx45
emailx45
emailx45
  • Question
Let's talk about Vars, Constants and ResourceString in Delphi
Replies
0
Views
111
emailx45
emailx45
emailx45
  • Question
How to load DLL static and dynamically in Delphi?
Replies
1
Views
248
emailx45
emailx45
emailx45
  • Question
How to catch "MOUSE CLICK/MOVE" in any place on screen ( IN or OUT form area / application) using MouseHookProc() - my way >:)
Replies
0
Views
157
emailx45
emailx45
emailx45
  • Question
How about we talk about "Class Operators" overloading in Delphi?
Replies
1
Views
114
emailx45
emailx45

Part and Inventory Search

Sponsor

Back
Top