Dimitry,

He wants to know if rolling back a parent transaction will roll back a
committed child transaction.

Regards,

Robert

----- Original Message -----
From: "Dimitry Sibiryakov" <SD@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, July 07, 2004 3:44 AM
Subject: Re: [firebird-support] Nested Transactions


> 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.
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>