| Subject | Re: [ib-support] Heterogeneus querys |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-04-28T13:50:07Z |
At 08:24 PM 28-04-01 -0400, Yoel wrote:
If you want a component to do it in your application, the same tool is a component in the native IB Objects (TIB_Datapump). It's not compatible with IBX though.
In principle, you just need two connections, one for the source and one for the destination, and one transaction to bridge a SELECT query attached to the source and an INSERT query attached to the dest.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
> Hello,InterBase doesn't support heterogeneous queries (if you are talking about joins between tables in two different databases). I've heard of a technique to emulate UNIONing rows from tables in two databases in Delphi, using TClientDataset, but I haven't tried it.. I don't think you get TClientDataset in D5Pro though.
>
> 1- Could anyone adwise, how to work with more than one IB database and
>buid heterogeneus querys, to link info in database ?
> 2 - Move data betwen IB Databases.If you want a tool to do it, see the DataPump tab in the free IB_WISQL tool downloadable from www.ibobjects.com.
If you want a component to do it in your application, the same tool is a component in the native IB Objects (TIB_Datapump). It's not compatible with IBX though.
In principle, you just need two connections, one for the source and one for the destination, and one transaction to bridge a SELECT query attached to the source and an INSERT query attached to the dest.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________