Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>Thanks Ko for your answers..
>I think I havn't explaines my self well...
>
>I have the same table on remote sites, I want to unite the data together on a central station. I have a primary key on the "jobno" field. I use the APPEND FROM to a zapped empty table, and on the first append I get the unique key violation.
>
>I'm not sopposed to have duplicate values because each site has it's own set of numbers.
>
>In hope to get more good advice,
>Thanks,
>Gadi Hutt
Then it should work, but are you sure that you have the same field lenghts on both the 'client' side and the 'server' side?
And is there a primary key index on the 'client' side too? If not then you have the change that the clients data isn't unique.
HTH
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