Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add new record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Divers
Thread ID:
00171529
Message ID:
00171534
Vues:
26
>Happy new year to all....
>I can't add a new record into my table. It says "Primary key uniqueness violated" How comes the problem?

Are you trying to APPEND BLANK the new record? The most typical scenario: If you do not have the default value (or function which generates the unique key for your Primary Key field) it means that when you append the second blank record to the table you have 2 records with the blank key field which violates the uniqueness. Yo can use also INSERT INTO ... VALUES instwad APPENDand assign the primary key in this statement.

Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform