Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Index
Message
De
06/04/2001 16:14:35
 
 
À
06/04/2001 15:10:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00492553
Message ID:
00493045
Vues:
22
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
Fil
Voir

Click here to load this message in the networking platform