Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete record
Message
 
To
08/06/2008 14:53:56
Ransome So
Ransome's Workshop
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01322406
Message ID:
01322408
Views:
7
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform