Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View - tableupdate philosophy problems.
Message
From
27/11/2000 17:09:28
 
 
To
27/11/2000 16:04:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00444385
Message ID:
00445882
Views:
22
>>I thought ALL changes were buffered and therefore were revertable at any time.
>
>They are, if you use Table buffering and not Row Buffering. Row buffering is the only kind that commits changes without you asking, and is therefore IMO, _never_ a good idea.

I did use table buffering. What I did was place a parameterized view in a grid. In the refresh method I update the parameter with the PK of the header table and Requery. This works fine until I add/delete a record in the line item (the one in the grid) view. If I don't EMEDIATELY tableupdate, when I do a ThisForm.Refresh() I get a changes not committed to lines (the view) error. The only way I have been able to deal with this is to not do a Requery in EditMode. VERY confusing.

Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.

MCP( Tcp/Ip )
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform