Devart Forums

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.

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

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.

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.

Thanks, I sent in the request yesterday.

And the fix works. Great and thanks a lot.