General information
Category:
Coding, syntax & commands
Title:
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only