Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Pamela:
> I set the filter to deleted() and search for the current entered record. If the record exist and has been marked for delete, I issue a RECALL for that record. For some reason this code is not being executed and it is attempting to do the default add and therefore, gets the uniqueness error.
Temporarily change the Deleted setting to off.
Attempt to locate a record having the same pk.
If found and deleted, recall it.
Restore the deleted setting.
It's a good idea to use the debugger to trace what is happening because you will want to examine the settings if deleted records are not found.
There is no nothing wrong about recalling deleted records, especially if the PK value means something and a deletion more or less indicates that the record is no longer used for data entry in the system (similar to an Active flag).
Daniel
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