Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need guidance on transactions
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00659716
Message ID:
00670945
Views:
19
>I always do something like this > >
>ll_OK = TableUpdate(.T., .F., <Alias1>)
>ll_OK = iif(ll_OK, TableUpdate(.T., .F., <Alias2>), ll_OK)
>ll_OK = iif(ll_OK, TableUpdate(.T., .F., <Alias3>), ll_OK)
>...
>
>if ll_OK
>  END TRANSACTION
>  wait window "Yup!"
>else
>  ROLLBACK
>  =TableRevert(.T., <Alias1>)
>  =TableRevert(.T., <Alias2>)
>  ...
>  wait window "NOPE!"
>endif
>
> >but the effect is exactly the same just with a little >less "depth" and writing

Hello Frank.
I read in some phorum that it is not necessary and even detrimantal to put TABLEREVERT after ROLLBACK.
They said that ROLLBACK does the whole job.
Kamil.
A moment of silence is our cosmic reset button.
Previous
Reply
Map
View

Click here to load this message in the networking platform