Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to control view updates
Message
From
26/11/2002 08:19:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
26/11/2002 08:13:35
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Netherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00726867
Message ID:
00726914
Views:
16
>When i open myview, and replace some values, those values get also replaced in the base table. without using tableupdate()

When you use row-buffering (2 or 3), only a single record can be in the buffer at any one time. In that case, TableUpdate() is done implictly as soon as you go to another record.

Either change to table buffering (4 or 5), or make sure your form explictly saves or discards changes before changing to another record.

See CursorSetProp("Buffering").

>the only thing i have not done according to your logic is make the view updatable using dbsetprop() and cursorsetprop() but I thought I've done that thrue the use of the view designer.

That's right, the view designer takes care of the details. The only thing you have to do is CursorSetProp("Buffering"). You can also change options in the DataEnvironment.

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform