>>>Hello Vladimir,
>>>
>>>Thank for your reply.
>>>
>>>I have already solved the problem of the Deletion.
>>>But it have created a new problem.
>>>As i deleted a invoice and i add a new invoice with the same invoice no.
>(deleted previous), an error will be occured. (Primary key is not unique).
>How can i fix this problem ?
>>
>>What we do is we SET DELETED OFF before seeking the record using the
>primary key field. If found, we RECALL the record, else we do INSERTion,
>then SET DELETED ON again.
>>
>>
>
>What we do is multiply the primary key by -1 (assuming you are using
>numerics) when we delete any records.

Hmmm...that sounds better. But how if not numeric? Maybe replace it with SYS(2015) before deleting. What can you say Gene?