Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
***Logical Delete Record
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00022604
Message ID:
00022609
Vues:
33
>I have a Table with a key index field specified as 'Primary' type.
>I have 'SET DELETE ON'. When a record was deleted with
>the DELETE command, I wanted to append the same key
>into the Table, but it says "Uniqueness violated". Why is that so?
>Any advise please.....

Alvin

Delete does NOT remove the record from the table -- only PACK will do that. Just because you cannot see the record does not mean it still does not exist. You will either have to pack the table first or change the key value so it is unique.

HTH,
Tom
Tom
--------------------------------
Tom O'Hare
407-299-4268 -- tom@redtile.com -- http://www.redtile.com/
Independent Programmer Using Visual FoxPro, Visual Basic & more...
Operations Manager -- Virtual FoxPro User Group (VFUG)
http://www.vfug.org/ -- tom@vfug.org
President -- Central Florida FoxPro User Group (CFFUG)
http://www.redtile.com/foxpro/
Universal Thread Most Valued Professional (MVP)
http://www.transformation.com/foxpro/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform