Board index » delphi » multiple result sets and ms-sql

multiple result sets and ms-sql

Hi All,

my question is:

is there any way to work with multiple result sets
in ms-sql?
[From within d5 and BDE]
thanks in advance,
S

 

Re:multiple result sets and ms-sql


Kovary,

  Using the BDE, no, ADO, yes (check out NextRecordSet in Delphi's help).

Good luck,
krf

Quote
Kovary Adam <koa...@freemail.hu> wrote in message

news:3CC3FD62.2000807@freemail.hu...
Quote
> Hi All,

> my question is:

> is there any way to work with multiple result sets
> in ms-sql?
> [From within d5 and BDE]
> thanks in advance,
> S

Re:multiple result sets and ms-sql


  Do you mean multiple result sets within one data set?  If you have
master-detail relationships, you can use the TClientDataSet.  It handles
multiple nested record sets, (provided that you don't save them to disk and
try to reload as xml...there's a bug in the field links code that prevents
reloading the xml).  Check out the Help on client data sets...it's pretty
flexible.
-Howard

Other Threads