Subject EXECUTE BLOCK and isc_tpb_autocommit results in Exception
Author Wolfgang
Hi,

I use Delphi and IBObjects with FIrebird 2.1 (2.1.1.17910). To change the database I uses a script with an Execute Block:

[sql]
EXECUTE BLOCK AS BEGIN
if (not exists(select 1 from rdb$relations where rdb$relation_name = 'T_AQ_ASSQUARTAL')) then
execute statement
'CREATE TABLE T_AQ_ASSQUARTAL (
T_AQ_PAT_ID DOM_ID,
T_AQ_ASS_ID DOM_ID,
T_AQ_CHIP_IK DOM_IK,
T_AQ_QUARTAL DOM_ABR_CHECK,
T_AQ_LEISTSUM DOM_INTEGER
);';
END^
[/sql]

This work very fine - but if the transaction uses "isc_tpb_autocommit" I recieve this exception:

ISC ERROR CODE:335544333

ISC ERROR MESSAGE:
internal gds software consistency check (Too many savepoints (287), file: tra.cpp line: 2731)

I try to backup and restore the database - no change. Anybody with ideas to solve this problem?

regards
Wolfgang