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