Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem adding record with same deleted Primary Key value
Message
From
17/10/1997 12:38:29
Juan Kh
Dataprop Technologies
Sungai Petani, Malaysia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Problem adding record with same deleted Primary Key value
Miscellaneous
Thread ID:
00055190
Message ID:
00055190
Views:
61
Hello,

I worked on a table which has a primary index called "Key". This table is included in the DataEnvironment of one of my form, with Private DataSession. Problem occur when I tried to add (by APPENDing) a new record with a value which had been deleted previously. The message I got is "Uniqueness of Index KEY is violated." By PACKing the table after DELETEing a record would solve the problem. Is there any other way (other than RECALLing) which I could use back the same KEY value without having to pack the table? 'Cos I don't want to open the table as EXCLUSIVE.

Thanks,
juan
Next
Reply
Map
View

Click here to load this message in the networking platform