Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Tablerevert() not working
Message
From
02/12/1999 18:08:19
 
 
To
02/12/1999 14:03:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00297523
Message ID:
00298195
Views:
24
You need to be using TABLE buffering instead of row buffering. With table buffering, your changes are never written without you explicitly issuing a TABLEUPDATE().

>Hi Eric,
>I've tried several different combinations for the buffer settings and get the same results. The TABLE is updated immediately. As a matter of fact, I have several textboxes and after I leave EACH TEXTBOX, at the bottom in the status bar, I notice it says "Updated 1 record in 0.03 seconds". The latest set up is that the Form is set for OPTIMISTIC and the Views are set with using the Form's Setting. What the heck am I overlooking?
>
>
>>>Have a form that uses two views. The form is set for 'BufferMode=1' (Pessimistic). The cancel button simply selects view1 and then issues tablerevert(), then selects view2 and then tablerevert().
>>>The changes remain and don't revert back to original value. What am I doing wrong?
>>
>>You mean the data remains changed in the view, or the changes are written to the table? Is it possible thatyour views are row buffered, and changes are being committed without you knowing?
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform