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