> :-(
> 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?

You can't update/delete data in external tables. You only can insert or
select.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/

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