>>>Using VFP5...
>>>
>>>I have a table (table1) set up with record buffering. I then create an updatable local view from it. I change a field
>>>within the view and update as follows:
>>>
>>>View1 is made up of all records with table1.done<>.t.
>>>
>>>(for this example it finds one record so...)
>>>
>>>replace view1.done with .t.
>>>=tableupdate()
>>>
>>>Now when I requery() looking for view1.done<>.t. (as before) the record I just changed still shows up as if the update never
>>>happened. The update does happen when I exit the form. Can anyone clue me in to what I'm doing wrong?
>>
>>Both the view AND the table are buffered, so so need to issue 2 TABLEUPDATES, first the view, then the table. Better yet, don't buffer the table, then you just need 1 TABLEUPDATE, on the view.
>
>What you suggested works. But for kicks I decided to try your "better yet" method. I turned off all buffering at the form property. I then
>went to the DE and enabled optimistic row buffering on the view. It still exhibits the same behavior and I have to do the tableupdate
>on both the view and table. Any more tips?

No, I'm not sure what is going on. It's supposed to work < g >. Have you tried stepping through with the Debugger and, just before the TABLEUPDATE() for the view, seeing what buffering is for the table:

CURSORGETPROP("BUFFERING", "Tablename")