> I know you are using IBO, so why not run a multi-database
> transaction?

gulp

Is this possible ?

I didn't know it...

This would be a smart solution...

> Create an SP on the target database to receive parameters
> which are passed to it, via a prepared executable statement in your
> application, from a query on the source database.

something like

//update

start transaction
try
update table 1 of database A with <data>
update table 2 of database B with <data>
commit;
except
rollback
end;

> You can also automate this in a variety of ways, using the

replication components in IBO...

again I never heard of these components.

I will check.

Thanks a lot

Duilio