Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View - Writes only when close the form
Message
 
To
03/04/2000 22:45:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00354732
Message ID:
00354815
Views:
23
Joao,

Assume you have a view named MyView that updates a table named MyTable. Both are in the DE and both are buffered.

At the start both the view and the table are clean (that is no pending changes in them for updating). You make a change to the view. Now the view is dirty and it needs to be updated to write its changes. You TableUpdate the view which writes changes to MyTable (which is buffered and is now dirty, with pending changes).

In the above scenario you have updated the view but that caused the table to become dirty and you have not updated the table yet. When you close the form VFP will resolve the situation.

This situation is called double buffering, as the view is buffered and so is the table. If you must have the table in the DE and buffered, then you must TableUpdate the table after you do the view.
Previous
Reply
Map
View

Click here to load this message in the networking platform