Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete a record
Message
 
To
09/01/1999 14:41:48
Carla Silva
Http - Produtos Informaticos, Lda.
Odivelas, Portugal
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Miscellaneous
Thread ID:
00174372
Message ID:
00174373
Views:
19
>I have a table with one tag of primary type (compoud .cdx. index file), If I delete a record with command DELETE, and try again insert the same record with command INSERT-SQL, I have the following error message "Uniqueness of index is violated". I have to do the PACK command to insert this record, but I can´t open the table in exclusive mode to do the pack, because I`m programming in shared acess. I do not know why this happen because the SET DELETED is ON.
>
>Thanks

Errh Carla ...,

That is how primary keys are supposed to work. You eighter change the type of index, or you change the key.

... or you hope that somebody else gives you a more constructive answer but frankly I doubt it.

Marc

If things have the tendency to go your way, do not worry. It won't last. Jules Renard.
Previous
Reply
Map
View

Click here to load this message in the networking platform