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
Carla Silva