two odbc connect question!

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

2 messages

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

2 total messages Started by zhjin Thu, 05 Apr 2001 09:30

#5518

Author: zhjin
Date: Thu, 05 Apr 2001 09:30

14 lines
1137 bytes

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

Re: two odbc connect question!

#5526

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

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