>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.