Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Begin trans and end trans
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Begin trans and end trans
Miscellaneous
Thread ID:
00110054
Message ID:
00110054
Views:
52
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
Map
View

Click here to load this message in the networking platform