Information générale
Catégorie:
Codage, syntaxe et commandes
>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement