At 03:15 PM 27-09-00 +0200, you wrote:

>Hello,
>
>I use Delphi 5 + BDE to develop application using interbase 6.0.
>Heterogeneous BDE queries doesn't work good with interbase 6.0.

Actually, you should not be depending on the BDE to work with interbase 6.0
at all. The BDE IB driver doesn't support the IB 6.0 API.

>I use heterogeneous queries to exchange data in Paradox table between
>different interbase 6.0 databases.
>The advantage of paradox database for exhange:
>- the little space it take (only change are sent)
>- it is easy to send it join on a E-mail
>
>What I can do ?
>Use Oracle or another database which work fine with BDE ?
>Waiting for the successor of BDE ? When ?

There isn't going to be a successor. Borland is replacing the BDE with a
new data access architecture (dbDirect).

>Using Interbase Express ? But it is impossible to do heterogeneous query
>between two interbase databases.

With IB Objects, FIBPlus or IBX you can hook up two (or more) IB databases
to the same transaction and exchange data between them. InterBase supports
two-phase commit. What you can't do is heterogeneous JOINs, although you
can create a heterogeneously-joined dataset with the TClientDataset and
spin off some custom insert/delete statements from that... or use IB
Objects for full two-phase commit support.

>How to exchange data without BDE ?

It depends on what you are attempting to do. If you have full Paradox, you
can export an answer.db to a fixed-length text file and read it into your
IB databases as an external table. It won't work if you want to
export/import blobs, though.

>Using ODBC interbase with BDE ?

Forget the BDE for InterBase 6.0, with or without ODBC.

Using ODBC with BDE for Paradox is a possibility and developers are working
on BDE-independent ODBC drivers for InterBase.

hth
Helen


All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
___________________________________________________