TMSQuery.OpenNext question

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 14
Joined: Sat 21 Oct 2006 11:42

TMSQuery.OpenNext question

Post by RandySill » Sat 21 Oct 2006 17:01

Is there any way to determine if a query is a multiresult query? Surely when the command is passed to the server the query component knows if there is another resultset available. When multiresult is executed from SQL Manager, both results are displayed. I would like to be able to emulate this behavior with SDAC.


Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Mon 23 Oct 2006 08:15

You can use construction like following

Code: Select all

  while MSQuery1.OpenNext do begin
    // your code

Posts: 1
Joined: Wed 12 Jul 2006 09:01

Post by stancosti » Mon 06 Nov 2006 13:01

if there any other method to know how many resultsets are returned from the server?

using while MSQuery1.OpenNext do... opens all resultsets.

i'm looking for something like ResultCount to iterate.

and also, how may i display two resultsets the same time? calling OpenNext will only display one.

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Tue 07 Nov 2006 10:50

SDAC doesn't support such functionality.
You can not navigate through multiple recordsets in such manner or display several recordsets from one instance of TMSQuery component at the same time using SDAC.

Post Reply