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