Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key
Message
From
20/07/2001 02:38:11
 
 
To
20/07/2001 02:12:14
Javed Yusuf
Analytic Systems
Lahore, Pakistan
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00532997
Message ID:
00533002
Views:
19
>Hello every body,
>
>I have problem with primary key, when I delete record and enter new record with same value in primary field error come value already exist. If any body has a solution, please reply

You need to have a .NOT.DELETED() filter on the PK, or you need to use surrogate keys so you never reuse them. I prefer the second choice.
Previous
Reply
Map
View

Click here to load this message in the networking platform