>Here's the scenario
>
>A Buffered View on a Buffered Table is open and fields in the view are updated. Issued a TableUpdate(.T.) command on the view which returned .T. and then we looked at the base table while it was still open and the changes were recorded. We then requeryed the view and no changes reflected. Table still shows the changes. Closed view and table. Reopened table and changes are gone.
>
>What did we miss???? Any help is appreciated.
If you want to have a buffered view and a buffered table open in the same work area, you are going to have to deal with the "double buffering" that results. Issuing a TABLEUPDATE on the view only writes the data from the view to the buffered copy of the table. If you want the data written to the base table from the buffered copy, you have to issue a TABLEUPDATE on the table as well.
Erik Moore
Clientelligence