>>Are you trying to update and delete the same record? If so you have to do that in two steps, first update and then delete.
>
>Thanks, Sergey. However, is this the only way to work around it? Any tricky method to do that in one step?
The better way would be to keep audit records with key field(s) and deletion date and any other relevant info in the separate table. This will work for any backend not only VFP.
--sb--