David, There are two Ways:
First Way:
DELETE
PACK
and another Way is after Delete
REPLACE ProductID WITH SYS(2015)
I wish you success
>I have a table called Product with a field called ProductID, and the ProductID is the primary key of the table.
>
>When a user creates a record with ProductID = 'ABC', and then deletes it, and then creates it again, i receive a dup primary key error, because the deleted record still exists as a marked-delete record.
>
>I would like to know how can i create a primary key on ProductID without this problem?
>
>Thanks,
>David Fung
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst