Hi!

>> As discussed in the German newsgroup, it might be related to one of
>> Dmitry's fix in November 2010 in the Firebird 2.5 code branch.
>>
>> Are you able to test your script under Firebird 2.5?
>
> sorry, I postet here yesterday morning earlier than in Delphipraxis.
>
> I try to execute my script with isql - but I don't know how to set the transaction to isc_tpb_autocommit. I found nothing in Helens book, supplement or the release notes...

In isql, there is no auto commit in general, except for DDL statements
(SET AUTODDL ON).

> The script runs without isc_tpb_autocommit in isql (and IBExpert and in IBObjects).

I wouldn't use some kind of auto commit when running a SQL script,
except the one for DDL statement if needed. I would disable auto commit
and put explicit COMMIT statements in the SQL script. This way, you have
full control over what's happening.

--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!