>In my system, delete record is not an avoidable event.
>I delete the record by delete command only(mark the record deleted), I physically remove them sometime in the program by the Pack.
>When the record is marked for deleted, it still violate the pirmar key rule. If the deleted record have the same key value.
>How can I solve this problem? I solve it by include !deleted() in the primary key definition. Is it the best method?
I am implementing the same method in all my primary key indexes.