Tag Archives: database is locked

Solution to SQLite error database is locked

Connect the SQLite database with firedac, bind the field name to the space tdbedit, and the following statement will report an error when modifying its value

procedure   TForm1.Button3Click(Sender:   TObject);
begin

  fdquery.Edit;
  fdquery.FieldByName(‘name’).AsString:=’test2′;
  fdquery.post;    // An error is reported here  [ FireDAC][Phys][SQLite]   ERROR:   database   is   locked.   It’s the same with refresh

end;

 

Set connection parameters for SQLite   LockingMode=normal   Solved