Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rollback transaction... tablerevert needed?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Rollback transaction... tablerevert needed?
Miscellaneous
Thread ID:
00353806
Message ID:
00353806
Views:
56
Using vfp5...

in the click method of a "save" button

begin transaction
replace status.numemployees with status.numemployees + 1
tableupdate(.t.,.t.)
if thisform.text1.value > 0 then
replace employee.age with thisform.text1.value
tableupdate(.t.,.t.)
else
rollback
return
end transaction

Question is... do I need a tablerevert before the "rollback" to return "status" to it's original
state or will the rollback handle it?

Note: I know the logic in this example is bad but it is just to demonstrate my point.
Next
Reply
Map
View

Click here to load this message in the networking platform