>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?
You can replace the key with some other thing like Sys(2015) and then delete the record.
Alexandre Nobre
Alpha Bytes Computer Corp.
Did you know that there are innocent people dying in East Timor?
It helps if you do...
I suppose you don't need glasses if you're able to read this line