Em 13/4/2010 17:43, Alberti Tamas escreveu:

> Hi!
>
> I have a question about transactions. My plan is that a stored procedure
> logs its job in a database table, tought if the client rollback the
> transaction, the log inserts will be also rolled back. Is there any way
> how i can keep some inserts in a transaction? For example i start
> another transaction in the proc or do some inserts outside the
> transaction, what the client initiated?
>
> thanks
>
> Tamas Alberti
>

In the current fb versions you could use external tables that does
survive to a rollback.

In the upcomming FB 2.5 you will have autonomous transaction

see you !


--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br