🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: two odbc connect question!

#5526
From: Patrick Martin
Date: Fri, 06 Apr 2001 00:35
56 lines
2335 bytes
This is a multi-part message in MIME format.
--------------3CDBF0547A1744279F1DF731
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

The BDE supports "heterogenous queries" in a magical way, allowing this to be
done, and it can access ODBC (in versions above statndard)

See the BDE help

HTH

zhjin wrote:

> hi
>   i hava a question. i'm use c++build and want to build a query.
> i have two ODBC source A and B.
> now i want to build a query from table from two ODBC, if now i'm using ODBC
> A,
> how can i retrieve data from ODBC B in a select query?
>
> i can't use: select * from a(in ODBC A) where id in (select id from b (ODBC
> B))
> help me please!
>
>   thanks
>
>   zhjin

--------------3CDBF0547A1744279F1DF731
Content-Type: text/x-vcard; charset=us-ascii;
 name="patrickmmartin.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Patrick Martin
Content-Disposition: attachment;
 filename="patrickmmartin.vcf"

begin:vcard 
n:Martin;Patrick
tel;pager:na
tel;cell:07773013982
tel;fax:na
tel;home:01483 303496
tel;work:na
x-mozilla-html:TRUE
url:http://www.freenetpages.co.uk/hp/patrickmmartin/
adr:;;72 Stoke Fields;Guildord;Surrey;;UK
version:2.1
email;internet:patrickmmartin@freenet.co.uk
title:Dr.
note:This is Patrick's home vcard
x-mozilla-cpt:;20176
fn:Patrick Michael Martin
end:vcard

--------------3CDBF0547A1744279F1DF731--
Technical Details
Message-ID: <3ACD0F3C.B8D0CD41@freenet.co.uk>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews
References: <3acc3f8b_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,81929595e13caa7d
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-04-05 17:33:20 PST
Message-ID: <3ACD0F3C.B8D0CD41@freenet.co.uk>
Date: Fri, 06 Apr 2001 01:35:08 +0100
From: Patrick Martin <patrickmmartin@freenet.co.uk>
X-Mailer: Mozilla 4.76 [en] (Win95; U)
X-Accept-Language: en,fr
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: two odbc connect question!
References: <3acc3f8b_1@dnews>
Content-Type: multipart/mixed;
 boundary="------------3CDBF0547A1744279F1DF731"
NNTP-Posting-Host: 212.1.148.170
X-Trace: dnews 986516765 212.1.148.170 (5 Apr 2001 17:26:05 -0700)
Lines: 57
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews