Combining result sets from multiple servers

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Alex Ip Sat, 18 Dec 1999 00:00

#1377

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads