Information générale
Catégorie:
Codage, syntaxe et commandes
> 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?
the best way is wither to recycle the deleted record (IE clear all the other fields and
RECALL it)
or use a primery key which is not data depended (ie that you can delete and forget)
Arnon
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement