I must be missing someting simple but can not understand why this is happening:

I have a table buffered view 'vActs' I want to delete a record from the view and also the underlying table. The original code I use is:

lLastAct = RECNO('vActs')
DELETE IN vActs
=TABLEUPDATE(1,.T.,'vActs')
=REQUERY('vActs')

When I run this I get an error on the Requery say there are uncommitted changes in vActs

I tracked it down to the Tableupdate not updating the table (which I also cannot understand why) so I changed the code to:

lLastAct = RECNO('vActs')
DELETE IN vActs
IF !TABLEUPDATE(1,.T.,'vActs')
=TABLEREVERT(.T.,'vActs')
Endif
=REQUERY('vActs')

This works with out error and deletes the record in the underlying table also. But what I cannot understand is that if I revert the table how does the change get written to the table (It must since the Requery returns the correct records with the deleted one gone).

The only other thing is I have SET DELETED ON but don't see how that would affect things.

Any ideas??

TIA Ken