View Single Post
 
Old 08-06-2018, 06:48 PM
larshgf larshgf is offline
Senior Member
 
Join Date: Jan 2001
Posts: 237
Default FireDAC SQLite ERROR

Hej Liste,

I have created a small database in SQLite with only one table (just in order to check out SQLite). The Table is defined like this:

CREATE TABLE IF NOT EXISTS "Gloser"(
GRAESK VARCHAR(50) NULL,
DANSK VARCHAR(50) NULL,
LEKTION VARCHAR(10) NULL,
NOTE TEXT NULL
);


I use Delphi 10.2 and the FireDAC components.
When I (in my Delphi program) try to write to the database like this:


fdqFlashCard.Append;
fdqFlashCard.FieldByName('GRAESK').AsString:= 'gręsk';
fdqFlashCard.FieldByName('DANSK').AsString:= 'dansk';
fdqFlashCard.FieldByName('LEKTION').AsString:= 'lektion';
fdqFlashCard.Post;

Then I get this error:

[FireDAC][Phys][SQLite]ERROR: Attempt to write a readonly database

I have been searching without a result. Anybody with a helping hint?

BR Lars
Reply With Quote