Article View: borland.public.cppbuilder.database.ado
Article #5526Re: two odbc connect question!
From: Patrick Martin
Date: Fri, 06 Apr 2001 00:35
Date: Fri, 06 Apr 2001 00:35
56 lines
2335 bytes
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!dnewsReferences:
<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