Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to control view updates
Message
De
26/11/2002 08:19:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
26/11/2002 08:13:35
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00726867
Message ID:
00726914
Vues:
17
>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)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform