Combining result sets from multiple servers

Article View: borland.public.cppbuilder.database.multi-tier

Article #1377

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1377

From: Alex Ip
Date: Sat, 18 Dec 1999 00:00

22 lines
1578 bytes

Hello all...

	I am trying to figure out the best way of using Borland's
MIDAS stuff to retrieve multiple result sets from a single query
posted to a number of different servers running the same database
schema. Is there any neat way of combining all of these into a single
dataset other than by the slow method of copying each individual
record into a temporary table? The TBatchMove component is of no use,
since the TClientDataSet component is not descended from TBDEDataSet.

	So far the test application I have written can happily
retrieve the individual result sets and I can view each of them
individually. Another problem I am facing is how to open each of the
TClientDataSets in a separate thread for concurrency, but I have put
that problem in the "too hard" basket for the moment. I am very new to
the wonderful world of multi-tier database applications, so any help
would be greatly appreciated. Thanks in anticipation.

Regards,

        Alex Ip
        ipai@mpx.com.au

Technical Details

Message-ID: <385bfa70.75479464@news.mpx.com.au>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,68cc155d75570dd8,start
X-Google-Attributes: gidfcd2b,public
From: ipai@DeathToSpammers.mpx.com.au (Alex Ip)
Subject: Combining result sets from multiple servers
Date: 1999/12/18
Message-ID: <385bfa70.75479464@news.mpx.com.au>
X-Deja-AN: 562439088
X-Complaints-To: abuse@mpx.com.au
X-Trace: news1.mpx.com.au 945552582 15769 198.142.38.194 (18 Dec 1999 21:29:42 GMT)
Organization: Optus Internet
NNTP-Posting-Date: 18 Dec 1999 21:29:42 GMT
Newsgroups: borland.public.cppbuilder.database.multi-tier