At 01:53 PM 19/12/2004 +0100, you wrote:

>I'll look for components (using BCB6, do you have any good one in mind ?),
>but I'm also interested in my own function.

Well, the TIB_Datapump in IBO is the one I use. If you want a trial at
using it in action, download IB_SQL from the IBO website and give it a
try. Its datapump tool uses TIB_Datapump. IB_SQL gives you an interface
to set up a cross-database transaction, with a select statement in the
source pane and an insert or update statement in the destination pane. In
between are other panes where you can do custom mappings between the source
columns and the destination columns.

>Where can I find more data about cross-database transaction? Looking through
>your book, but haven't found it. Sorry if I missed it.

The index entry is "Multi-database transactions". There's not much to know
about them. You have one transaction that spans two or more
databases. You can read from or write to all of the databases within the
same transaction. Firebird has some built in protection for
committing/rolling back such transactions (known as two-phase commit) that
your application doesn't have to be aware of.

Helen