Query over 2 ADOConnetions ...

Thread View: borland.public.cppbuilder.database.ado

2 messages

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

2 total messages Started by Michael Brunner Mon, 26 Mar 2001 15:12

#5633

Author: Michael Brunner
Date: Mon, 26 Mar 2001 15:12

7 lines
971 bytes

Hi,
I have 2 ADOConnections in my project and I want to generate a 
SQL-Query over tables in the different databases. A Query points 
only to one Database, so how can I do this ???

Thanks for answer, Mike.

Re: Query over 2 ADOConnetions ...

#5642

Author: Mark Cashman
Date: Tue, 27 Mar 2001 00:29

22 lines
1751 bytes

Hi, Mike!

You can use a master / detail relationship, having the one data set /
data source feed the other.

You will need to use a parameter in the second query, which is to be
satisfied by the data source named in the DataSource property of the
second query. That data source will be the data source attached to the
first query, and the parameter named in the SQL will have the same name
as the appropriate field in the first query.

Follow the pattern used for BDE TQuery objects shown in the Developer's
Guide and the help.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

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