>>>Hi,
>>>
>>>I'm having some trouble attempting to APPEND or INSERT INTO a table contained in a DATABASE. The table has a primary key and I've deleted some of the previous records and then when I attempt to add new ones that might have the same key as some of the deleted ones, I get the UNIQUENESS OF KEY VIOLATED error. I believe DELETED is set off. The only way I can get this to work is to PACK the table, but then I have to open it exclusivly, and that poses some problems sometime.
>>>
>>>Has anyone delt with this before in a good way?
>>
>>Jim
>>
>>One way is to erase the contents of a 'deleted field' and re-use the existing field. Just basically fakeing the user to thinking it is a new record. It is sometimes called 'recycling'.
>>
>>HTH,
>>Tom
>
>This is not exactly the solution for his problem. Because the uniqueness is violated because the key already exists in another deleted record.
>
>Vlad
You did not understand. You 're-cycle' the record. Since you need to use that key again you just blank out the rest of the fields and re-use the record. This is one way of doing it, not the only way but it let's you use that key without packing the table.
Tom