>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

Each table has a record pointer; once you are on the correct record, just give the command DELETE.

If you want to go to the correct record first, you can do something like locate for MyField = ..., before deleting.

If you are on a form, you have to go to another record after deleting - this is not automatic. For example:

* User has already selected the correct record, in the grid for example
delete
skip
if eof()
  go bottom
endif
ThisForm.Refresh()

HTH,

Hilmar.