Hi Frans,
Honestly I didn't find topics that discuss my question
.
So in this special case where a duplicate of my new record exist in the database
but with its flag set to deleted you allow to create the new record and reuse the record number and don't throw a DuplicateException
In case the record's flag set to valid, you throw a DuplicateKeyException.
Did I understand you right?
Regards,
Darya