Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delete record
Message
 
À
08/06/2008 14:53:56
Ransome So
Ransome's Workshop
Hong Kong, Hong Kong
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Divers
Thread ID:
01322406
Message ID:
01322408
Vues:
8
>Dear all,
>
>How to delete a record from a table, I find that I can't delete a record sucessfully.
>
>Am I?
>Select Myfile
>Delete Myfield="ValueIWantToDelete"
>tableupdate(.t.)
>
>where
>Cursor.BufferModeOverride=3 (or 5)
>
>However, I still see the deleted record in my reocrd page.
>
>I have SET DELETED ON
>
>What I have overlooked ??
>
>It should be unfortunate to 'PACK' everytime I delete a record !
>
>
>Regards,
>
>Ransome
Delete Myfield="ValueIWantToDelete"
?
What is that command? You can't delete field :-)
I assume that as a typo.
TO hide deleted records you should mive records pointer from deleted record, so after you delete it just add one SKIP, something liks:
DELETE IN YourTable
SKIP  IN YourTable
IF EOF([YourTable])
   SKIP  -1 IN YourTable
ENDIF
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform