Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffer doesn't update
Message
From
22/11/1999 13:10:53
 
 
To
22/11/1999 13:06:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00293982
Message ID:
00293990
Views:
24
>In MyForm init:
>SET MULTILOCKS ON
>CURSORSETPROP("buffering",5,"MyView")
>CURSORSETPROP("buffering",5,"MyTable")
>Buffermodeoverride is set to 1 on both.
>
>In save button click:
>TABLEUPDATE(1,.T.,"MyView")
>
>In revert button click:
>TABLEREVERT(.t.,"MyView")
>
>The revert button works, at least it changes the records in the grid back to what they were before the changes were made.
>
>But the save button does not save the changes to the original table (MyTable).
>
>What am I missing?

You don't need to open the table in the same DE as the view. As a matter of fact, doing this causes a "double buffering" situation, where the changes from the view are written to the buffered copy of the view, and not to the base table. If you need the table open as well, YOu'll have to execute a TABLEUPDATE on the table to get the changes back to disk.
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform