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
Similar Posts:
- SVN:sqlite[S5]:database is locked [How to Solve]
- Sqlite – constraint failed[0x1555]: UNIQUE constraint failed
- Using SQLite to show undefined reference to ` SQLite3_ open’…
- How to Solve Navicat Remote Connection to MySQL is Stuck
- Fatal error: Uncaught Error: Class “SQLite3” not found in C:\Code\phpcode\phpbk\tt.php:2 Stack trace: #0 {main} thrown in C:\Code\phpcode\phpbk\tt.php on line 2
- Mongodb access control is not enabled for the database
- An error is reported when the SVN is submitted. The prompt is locked and cleanup is required
- [How to Solve] SQLite database error: no such column
- [Solved] Node Error: DeprecationWarning: current URL string parser is deprecated and Port 3000 is already in use
- The database could not be exclusively locked to perform the operation (SQL Server 5030 error solution)