What may be happening is that not only is your view buffered, but your table is also buffered. So when you issue a TABLEUPDATE() on the view, it updates the buffered table. Then, if you issue a TABLEUPDATE() on the table, it will actually write the changes to the disk.

You can fix this by making sure your table is not buffered.

Also, make sure you check the return value of TABLEUPDATE(). If the update did not work, it will return .F.

>How can I sure that the base table have been updated? Does it means when I issue TABLEUPDATE() command at view, the append data will update at base table? or I need to issue another TABLEUPDATE() at base table??
>
>I face a problem when I append a new record to view. After I issue the TABLEUPDATE() command at view (user click Save Button), if user press Edit button and modify the data, and save it immediately, system will prompt me UPDATE CONFLICT.
>
>I solve it by move the base table record pointer(GO TOP...) once user update the view.
>
>I think this is not a proper solution. Can anyone tell me how to solve it?
>
>TIA.