COMMIT TRANSACTION ?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

COMMIT TRANSACTION ?

Post by ACDC »

When Why and How would i use COMMIT TRANSACTION, anyone care to present a scenario ? :)
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: COMMIT TRANSACTION ?

Post by BLOMASKY »

I use it often.

1st, I often call a stored procedure at the end of an aware process. I have to commit so that the SP can read / update the correct data. (I use many SPs in my apps.)

2nd, I sometimes update something in SystemSettings in the middle of a long process. (One that prompts user for info ) and want to make sure when other users read SystemSettings they get the current version.

Bruce
ACDC
Posts: 1138
Joined: Sat Jun 30, 2007 5:03 pm
Location: California, USA

Re: COMMIT TRANSACTION ?

Post by ACDC »

Thanks , that makes sense, I can see in some of my processes it could be used rather than dropping down (referring to) another process in the sequence
Post Reply