COMMIT TRANSACTION ?

ACDC

When Why and How would i use COMMIT TRANSACTION, anyone care to present a scenario ? 🙂

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

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