Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to control view updates
Message
De
26/11/2002 11:14:50
Victor Verheij
International Film Festival Rotterdam
Rotterdam, Pays-Bas
 
 
À
26/11/2002 08:19:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
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:
00727052
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform