Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Begin trans and end trans
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement