Hi Tamas Alberti,

I don't know what language you are usingo to do it...
But on Delphi I do it using two IBTransactions... I commit only one
Transaction and I rollback the other one...

You can do it opening two transactions...

best regards,

Rodrigo Ap. Cardoso



Em 13/04/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
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
>

--

!* Rodrigo Aparecido Cardoso*
: Data System Informática -- Analista de Sistemas
( 55 (19) 3701-6600
* rcardoso@... <mailto:rcardoso@...>


[Non-text portions of this message have been removed]