Subject | error "Transaction is not valid for the current connection" |
---|---|
Author | bausufm |
Post date | 2011-09-07T07:07:01Z |
Hi,
with IBO 4.6 the following code snippet runs without error.
On IBO 4.9 (latest build) it runs into error!?!?!
procedure TForm1.btnTAProblemClick(Sender: TObject);
var
qr : TIB_cursor;
cn : TIB_Connection;
ta : TIB_transaction;
begin
cn := nil;
qr := nil;
try
ta := TIB_Transaction.Create(Self);
ta.starttransaction;
cn := TIB_Connection.create( self);
cn.defaulttransaction := ta;
cn.Username := 'SYSDBA';
cn.password := 'masterkey';
cn.protocol := cpTCP_IP;
cn.database := eDatabase.text;
cn.connected := true;
qr := TIB_cursor.create( self);
qr.IB_Connection := cn;
qr.sql.text := 'select * from rdb$database';
qr.prepare;
qr.open; // with IBO 4.6 ok.
// with IBO 4.9 error with message "Transaction is not
// valid for the current connection"
except
on e:Exception do
Showmessage(e.message);
end;
qr.close;
cn.close;
ta.rollback;
qr.free;
cn.free;
ta.free;
end;
Is this a known incompatibility between IBO 4.6 and 4.9?
Is it a bug?
Or did I missed something?
Regards
Falko
with IBO 4.6 the following code snippet runs without error.
On IBO 4.9 (latest build) it runs into error!?!?!
procedure TForm1.btnTAProblemClick(Sender: TObject);
var
qr : TIB_cursor;
cn : TIB_Connection;
ta : TIB_transaction;
begin
cn := nil;
qr := nil;
try
ta := TIB_Transaction.Create(Self);
ta.starttransaction;
cn := TIB_Connection.create( self);
cn.defaulttransaction := ta;
cn.Username := 'SYSDBA';
cn.password := 'masterkey';
cn.protocol := cpTCP_IP;
cn.database := eDatabase.text;
cn.connected := true;
qr := TIB_cursor.create( self);
qr.IB_Connection := cn;
qr.sql.text := 'select * from rdb$database';
qr.prepare;
qr.open; // with IBO 4.6 ok.
// with IBO 4.9 error with message "Transaction is not
// valid for the current connection"
except
on e:Exception do
Showmessage(e.message);
end;
qr.close;
cn.close;
ta.rollback;
qr.free;
cn.free;
ta.free;
end;
Is this a known incompatibility between IBO 4.6 and 4.9?
Is it a bug?
Or did I missed something?
Regards
Falko