I am looking for a way to perform multiple database operations as a single atomic transactions, such that either all database operations succeed or none of them. In practice this typically involves marking the start of a transaction, perform all operations and then either end the transaction if all successful or, on failure, rollback all database operations since the marked transaction start. An example in pseudo could could be:
TRANSACTION_START( );
while( record.next( ) ) {
record.someField += 1;
record.update( );
}
TRANSACTION_END( );
In this example we update all records we've found and set someField to its value +1. Now if any of these updates fails, e.g. due to a business rule or ACL, all of the updates should be reverted (for whatever reason). Is there any such a construction present in the GlideAPI? The features documented in the wiki do not describe such a thing, while (I think) all DB engines implement this (see e.g. Introduction to Transactions - SQLTeam.com)
Thanks in advance,
Joris
