FetchAll and multiple result sets

yeohray · Post by **yeohray** » Thu 28 Feb 2008 15:09

I've been looking into the FetchAll property, to set it to false to reduce the memory consumption when retrieving large result sets. However, it appears that only the first result set is retrievable when FetchAll is false.

E.g. if I have these 2 commands in TMSQuery:

SELECT TOP 10 * FROM sysobjects
SELECT TOP 10 * FROM sysindexes

If FetchAll is True, I can retrieve the 2nd dataset by using the OpenNext method. However, if FetchAll is False, OpenNext returns false.

Is this a bug?

Thanks.

Antaeus · Post by **Antaeus** » Mon 03 Mar 2008 16:49

Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next SDAC build.

yeohray · Post by **yeohray** » Tue 04 Mar 2008 05:52

Thank you, I know that this issue has long been a problematic issue for you guys. I hope the OnInfoMessage event for multiple result sets still works after the fix.

Antaeus · Post by **Antaeus** » Tue 04 Mar 2008 09:11

We tested the OnInfoMessage event with this fix. Our test detected no problems with it. We can send you the fix by e-mail to make sure that this fix works properly in your case. For that you should send your registration information to the SDAC support address.

yeohray · Post by **yeohray** » Wed 05 Mar 2008 15:05

Thanks, I sent in the request yesterday.

yeohray · Post by **yeohray** » Tue 11 Mar 2008 03:21

And the fix works. Great and thanks a lot.