SWAG - may be you need to move pointer after delete?

>Hi Neighbor,
>
>The underlying table isn't buffered.
>
>And yes, it should be Upper(Left(m.HomeTown,1))+Substr(m.HomeTown,2)
>
>Ken
>
>And it sh>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