Subject | EXECUTE BLOCK and isc_tpb_autocommit results in Exception |
---|---|
Author | Wolfgang |
Post date | 2011-02-02T18:29:45Z |
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
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