Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Begin trans and end trans
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Begin trans and end trans
Divers
Thread ID:
00110054
Message ID:
00110054
Vues:
53
Hello All;

We've gotten a little confused between a number of functions
and how they interact wit hthe database. Any insight into these
issues would be greatly appreciated!

Inside our DBC, we have the validations, triggers etc.

1) use mytable in 0 shared
2) select mytable
3) set multilocks on
4) =cursorsetprop('Buffering',5)
5) begin transaction
6) append blank
7) replacing and other stuff
8) end transaction
9) use in mytable
10) use mytable

At this point, all changes are gone.
This is where our confusion lies. If I do not use the cursorsetprop,
then all the validations in the DBC set in before we actually
even start to do anything. The help in VFP5.0 clearly states
that end transaction saves all changes made to tables.
We are trying to avoid writing tableupdate for each table that
may or may not be involved.

So the question is Can buffering be used inside a transaction??

Thanks
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform