Great!
I was trying to make it with IBObjects transaction component, but it
seems that its SavePoint method is not the same as the one you describe
(from SQL).
Now it works.
Thanks.
Luis R.

Roman Rokytskyy escreveu:

>
> > Is it possible to nest transactions with the same IB_Transaction
> > component?
>
> The nested transactions in Firebird are called SAVEPOINT. You can set
> savepoint using "normal" query
>
> SAVEPOINT savepoint_name;
>
> If you need to rollback the nested transaction, you execute
>
> ROLLBACK TO savepoint_name;
>
> If you no longer need the savepoint (in other words you're sure that
> you won't rollback to it), you can release the savepoint using
>
> RELEASE SAVEPOINT savepoint_name;
>
> All these queries are executed using normal query component that is
> assigned to your main transaction.
>
> Roman
>
>