can't find database after realocating tdataset lazarus / 16-Databases ---------------------------------------------------------------------- mangakissa · 2016-03-16 20:31 Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i procedure TForm1.FormShow(Sender: TObject);begin  memo1.Lines.add('open connection');  DataModule1.IBConnection1.Open;  memo1.lines.Add('status connection : ' + booltostr(DataModule1.IBConnection1.Connected,true));  DataModule1.SQLQuery1.DataBase := DataModule1.IBConnection1;  DataModule1.SQLQuery1.Transaction := DataModule1.TrTestTabel;  fcurrentdataset := DataModule1.SQLQuery1;  memo1.lines.Add(TSQLQuery(fcurrentdataset).Transaction.Name);  fcurrentdataset.Active := true;  memo1.lines.Add(TSQLQuery(fcurrentdataset).Transaction.Name);  sleep(5000);  fcurrentdataset.active := false;  memo1.Lines.add('close connection');  DataModule1.IBConnection1.close;  memo1.lines.Add('status connection : ' + booltostr(DataModule1.IBConnection1.Connected,true));end;  fcurrentdataset is declared asCode: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i fcurrentdataset : TDataset; As far as I know I give SQLQuery1 a pointer reference to fcurrentdataset. Changing  fcurrentdataset to TSQLQuery doesn't change a thing ---------------------------------------------------------------------- mangakissa · 2016-03-17 12:06 transaction was not connected to database.