Re: Query over 2 ADOConnetions ...

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

Article #5642

Back to borland.public.cppbuilder.database.ado Previous Next

#5642

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

Technical Details

Message-ID: <3ABFDED6.A0CFA416@temporaldoorway.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!213.56.195.71!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!news.bnb-lp.com!dnews!24.14.197.193

References: <3abf5c43$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,b511b4693167582d
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-03-26 16:44:49 PST
Message-ID: <3ABFDED6.A0CFA416@temporaldoorway.com>
Date: Mon, 26 Mar 2001 19:29:10 -0500
From: Mark Cashman <mcashman@temporaldoorway.com>
Reply-To: mcashman@temporaldoorway.com
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Query over 2 ADOConnetions ...
References: <3abf5c43$1_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.14.197.193
X-Trace: 26 Mar 2001 16:28:32 -0800, 24.14.197.193
Lines: 24
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!news.tele.dk!213.56.195.71!fr.usenet-edu.net!usenet-edu.net!fu-berlin.de!news.bnb-lp.com!dnews!24.14.197.193

Reply to Parent Message