Hi Claude,
>But then how to I get rid of the original record
The part that I don't understand is why do you create a new record in the first place? As far as I understand, your goal is to change a non-candidate field in a record. You get an error, because you perform an INSERT follwed by DELETE instead of an UPDATE or REPLACE operation.
--
Christof