Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What's Happening - No TableUpdate or was there?
Message
From
02/08/1999 19:49:53
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00249063
Message ID:
00249078
Views:
18
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform