Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to control view updates
Message
From
26/11/2002 11:14:50
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Netherlands
 
 
To
26/11/2002 08:19:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00726867
Message ID:
00727052
Views:
17
I think I understand it a bit better now.

I thougt that tablerevert() could be used to revert changes made to the base table but this is not the case. I also thought that i could revert changes to the view after i had allready did a tableupate().

How I understand things now is:
1) Tablerevert() has only effect on the view, only when a tableupdate() has not yet occured.
2) Use cursorsetprop('buffering',5) to set tablebuffering to optimistic table buffering, to avoid records being automatically updated.
3) Tableupdate() commits changes to the VIEW and makes these changes "permanent" and "forces" these changes back into the basetable.
4) The cursorsetprop('buffering',5) only applies to the view.
5) After the view is opened, changing the sendupdates property with "dbsetprop('myview',view','sendupdates',.t.)" doesn't have any effect within the current datasession.


Please feel free to comment :-)

Thanks
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform