>I want to recycle the deleted records in a table. Lets say the table is 'table1'. The 'table1' has a primary index on the field 'NO'. I have a record with the 'NO' value 5 and the record is marked deleted. If I append a record, set the 'NO' value 5. The message 'Uniqueness of index NO is violated'. I tried set deleted on. It won't help.
>
>To my knowledge, if the record is marked deleted when the set deleted on, logically it does not exist. Why I have the key violation? I don't understand. Help please?
>
>Jim S
Index covers all records (deleted and non-deleted) so primary index will require uniqueness of all records. If you want to recycle, you shouldn't append new record. You just recall deleted one and use it.
Edward Pikman
Independent Consultant