TMSQuery.OpenNext question

RandySill · 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.

Randy

Jackson · 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
  end;

stancosti · 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.

Jackson · 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.