On 7 Jul 2004 at 17:49, Actnow Accounting P/L wrote:

>Can you actually do this in Firebird ?
>
>TRANSACTION PARENT BEGIN:
> TRANSACTION CHILD BEGIN:
> UPDATE 1...
> UPDATE 2...
> UPDATE 3...
> TRANSACTION CHILD COMMIT
>TRANSACTION PARENT ROLLBACK
>
>resulting in undoing the child commit?

What difference between your example and the same action without
nested transaction? I.e. why you can't do just

TRANSACTION BEGIN:
UPDATE 1...
UPDATE 2...
UPDATE 3...
TRANSACTION ROLLBACK

SY, Dimitry Sibiryakov.