FireDAC SQLite ERROR

[larshgf]

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

[rojam]

Originally Posted by larshgf

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

What directory does your database sit on? Do you have WRITE access to that directory?