I do this code :
Code: Select all
procedure TForm1.Button1Click(Sender: TObject);
var
query: TIBCQuery;
tranc: TIBCTransaction;
begin
query:= TIBCQuery.Create(self);
query.AutoCommit:= false;
tranc:= TIBCTransaction.Create(self);
tranc.DefaultConnection:= IBCConnection1;
query.Transaction:= tranc;
query.Connection:= IBCConnection1;
query.SQL.Text:= 'SELECT * FROM data_10min';
query.Open;
if tranc.Active = true then begin
tranc.Rollback;
end;
tranc.Free;
query.Free;
end;
Thanks for help
Regards