Subject Re: [IBO] Nested Transactions?
Author ehandbury
--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@t...> wrote:
> Nope. InterBase doesn't support nested transactions. The only

Just thinking more... I'm surprised that IB doesn't have this
support. A solution for this would be either nested transactions or a
stack of savepoints within the same transaction with the ability to
rollback to the last savepoint.
Is there any future development in this area? Are there any RDBMSs
which support nested transactions?

The examples that could use this are endless. A Customer/Order
Entry system, for example. A user enters a new customer, then begins
to enter orders, adds an order and commits, then adds another order
but screws-up and deletes the order and re-enters it... all the while
having the ability to rollback the entire customer.