Could it be that your underlaying table is buffered also?

BTW, should not it be Arlington? :)

>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