SQLite3Connection1: Database is locked
lazarus / 16-Databases

----------------------------------------------------------------------
Jvan · 2021-05-31 21:06

I don't have any other software using the sqlite3 database.

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.Button2Click(Sender: TObject);begin  SQLQuery2.SQL.Text :=
'INSERT INTO test_001 (Campo_001, Campo_002, Campo_003) VALUES
(:CAMPO_001, :CAMPO_002, :CAMPO_003);'; 
SQLQuery2.ParamByName('CAMPO_001').AsString := Edit1.Text; 
SQLQuery2.ParamByName('CAMPO_002').AsFloat := FloatSpinEditEx1.Value; 
SQLQuery2.ParamByName('CAMPO_003').AsString := Edit2.Text;  
Edit3.Text:=SQLQuery2.SQL.Text;  SQLQuery2.ExecSQL(); 
SQLTransaction1.Commit();  end;

----------------------------------------------------------------------
Zvoni · 2021-06-01 06:20

Are you using the visual components?
Active in Object-Inspector?

IIRC, it was the same issue for me, and NOT using Object-Inspector to
set it to active solved it for me.