Look at these commands in Release Notes:
SAVEPOINT <identifier>;
ROLLBACK [WORK] TO [SAVEPOINT] <identifier>;
RELEASE SAVEPOINT <identifier> [ONLY];

Ivan

----- Original Message -----
From: "VOET Emmanuel" <emmanuel.voet@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, September 15, 2004 1:00 PM
Subject: [firebird-support] firebird and transaction


> Hello,
>
> I'd like to know if Firebird supports 2 levels of transactions.
>
> To be clear:
> I would like to open a main transaction I will be able at any time to commit or rollback. That exists for sure. But I
also would like inside that transaction, to open other ones I could commit or rollback as well.
> The objective is to implement a single undo function which was not planned before. Another possibility I have been
told, but I don't know for Firebird, it to set a serie of milestones you can at anytime in the main transaction rollback
to one of these.
>
> Thanks for your support,
>
>
> Emmanuel Voet