| Subject | Re: connection between two fdbs |
|---|---|
| Author | emb_blaster |
| Post date | 2008-09-01T16:43:47Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
object (based on a SELECT statement) to select the row from fdb1 and
another (an update or insert statement) to write its data to a row in
table in fdb2. Since you're using Delphi, there are components
available that wrap this kind of operation, e.g. the TIB_Datapump
component of IBObjects.
EXECUTE BLOCK construct.)
Well... as far I now you could copy many rows from 1.fdb 2.fdb using
Delphi, C++, etc... In fact, you cold do this even from a 1.mdb (or
other db file) to 2.fdb, this is what a DataPump soft do. But like
Helen said, you could not do this using a SQL statement in current
versions. So what you REALLY need?
>(with one connection each for fdb1 and fdb2), where you have one SQL
>
> >dirinler wrote:
> >>
> >> 2-i wantto connect two fdbs in the same project.i also wantto copy a
> >> row from 1.fdb to 2.fdb is this possible?
>
> Not in any current release. You need a multi-database transaction
object (based on a SELECT statement) to select the row from fdb1 and
another (an update or insert statement) to write its data to a row in
table in fdb2. Since you're using Delphi, there are components
available that wrap this kind of operation, e.g. the TIB_Datapump
component of IBObjects.
>EXECUTE STATEMENT call in a PSQL module (stored procedure, trigger or
> However it will be possible to do it in Firebird 2.5, using an
EXECUTE BLOCK construct.)
Well... as far I now you could copy many rows from 1.fdb 2.fdb using
Delphi, C++, etc... In fact, you cold do this even from a 1.mdb (or
other db file) to 2.fdb, this is what a DataPump soft do. But like
Helen said, you could not do this using a SQL statement in current
versions. So what you REALLY need?