Subject RE: [IBO] TIB_DataPump
Author Alan McDonald
> Hi Alan.
> I have two databases with identical structure.
> Starting with some identical data eg: People who works there,
> with their data.
> Now in a remote office people could insert or modify that data.
> This changes must be transferred into the other database which
> reside in the central office.
> So I need an insert/update datapump.
> In metacode:
>
> //*
> If exists PK then
> update
> else
> insert
> //*
> Thanks for the help.
> Ciao
> Arnaldo

Yes, so you are saying that the update works (which means the PK is found in
the destination db) but the insert fails with the PK violation message.
You are inferring that the message doesn't make sense but
do you have two PK constraints set on the target table which you have
forgotten about?
Maybe we should se more code behind this pseudo code you have?
Alan