:-(
it seems i cannot modify the records of the external table. I get an
error message: Cannot update rows in external files. Password required
It is a problem causssssse i would like to update the logged record in
some cases...

Any idea?

Alexandre Benson Smith wrote:

>
>
> 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 !