Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
If some of the columns/keys are defined as unique any update that causes a duplicate condition will be prevented.
Somewhere in the process the value ablut to be used to update must be checked to see if it already exists.
This same consideration should be checked for the condition wiere 2 of the "new" values are duplicates. They don't duplicate any existing values, but they might duplicate each other fro the new population..