General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only