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);

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



Set connection parameters for SQLite   LockingMode=normal   Solved

Similar Posts: