Hi, Alexandre

It doesn't sound like you use them in your application, but Firebird
1.5 now supports nested transactions:

http://www.firebirdsql.org/ff/foundation/FB15_New.html
(see "Transaction Savepoints")

Regards,
Walter

--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

> wperdigao wrote:
>
> >Just a thought, but maybe you have an outer parent transaction

that

> >is being rolled back (because of an error or crash) which
> >can "uncommit" the previously committed child transaction:
> >
> >TRANSACTION PARENT BEGIN:
> >
> > TRANSACTION CHILD BEGIN:
> > UPDATE 1...
> > UPDATE 2...
> > UPDATE 3...
> > TRANSACTION CHILD COMMIT
> >
> > UPDATE 4...
> > UPDATE 5...
> >
> >TRANSACTION PARENT ROLLBACK
> >--> Rolls back previously committed updates 1, 2, 3 and updates 4,

5

> >
> >Regards,
> >Walter
> >
> >
> >
> Walter,
>
> did you meant savepoints ?
>
> FB haven't nested transactions...
>
> see you !
>
> --
>
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda.
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br