On 14 Dec 2002 at 12:49, Shane Vincent wrote:

> I can agree with you that there shouldn't be a need for nested
> transactions, but sometimes, one developer might be working on a
> component, and another developer would be working on an interrelating
> component. As you can see there might be times when nested transactions
> might be something that could have some validity.

Actually, you have nested transactions in FB, sort of :-) Work done by
stored procedures or triggers is unwinded on error or user exception, so
if you want to use a "nested transaction" just in procedure or trigger
(not at app. level), you can throw and exception for rollback and use
WHEN command to define subtransaction blocks.

Best regards
Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information