VBcoders Browse New Submit Contact Sign In

No account? Register free

Forgot password?

Transaction Committ/Rollback

Jeff Ritchie  (2 Submissions)   Databases/Data Access/DAO/ADO   Visual Basic 3.0   Intermediate   Wed 3rd February 2021

This code allows for multiple record updates to be grouped into a single batch style transaction. You can then either committ changes to multiple records, or rollback the changes in the case of errors or conditions not being meet. This code is ideal for month-end processing, or in a situation where there is the possibility of errors being generated.

Side Effects
The workspace used is held in the mapped temp area of the hard disk. If disk space runs out an error will be generated.

Rate Transaction Committ/Rollback (2(2 Vote))

Download Transaction Committ/Rollback

Transaction Committ/Rollback Comments

No comments yet — be the first to post one!

Post a Comment

0/1000 characters