Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Add new record
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00171529
Message ID:
00171534
Views:
25
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform