If the view is buffered
and the source table of the view is buffered too, then the tableupdate() on the view will send the updates to the table buffer, not to the table. The table will then be updated, automatically, when the record pointer in it moves.
>I'm sure there is an easy solution to this, but I need your help. When I delete a record from a local view, I do a tableupdate() and a requery() but the record still shows as if it were there. If I try to delete it again, I get an "Update Error". If I exit the application then look again, it is gone. I tried the update with the force flag, same thing. What is the proper way to do this? I am using optimistic row buffering.
>
>TIA
Doru