>Hi All,
>
>I wrote a routine to upadte a central database with values from other databases.
>I use COPY TO and APPEND FROM commands. One of my tables has a primary key defined. When I issue the APPEND FROM I get a vaulation of that key.
>I checked the values and they are diffierent, I've PACK'ed the tables etc.. with no help.
>
>Is there somthing in the COMMAND syntax or env. settings I need to look at?
>
>Many thanks,
>Gadi

---

Probably you have deleted records in the table you are appending too.
And if you want to overwrite all the current values you also have duplicate keys.
You can zap the dest table first before you append from the source table