>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.
Chris McCandless
Red Sky Software