>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.