This sounds like a windows file access problem that is not letting your application access a file created in the context of a cmd box. Can you - from the sqlite shell - insert the desired record into the database? And select it afterwards? If so, then SQlite is working perfectly and it is your OS Setup that is in the way.
If you can't write to the database from the SQLite shell, then maybe your are in a read-only directory. Try creating a temp table (which should default to an in-memory database) and iserting/selecting there. -----Ursprüngliche Nachricht----- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Freitag, 10. August 2018 11:42 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: [EXTERNAL] [sqlite] (no subject) Hi SQLite-users, I have in the console prg (cmd) 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 ); As a programming language I use Delphi 10.2 (GUI Object Pascal) and their FireDAC components for handling SQLite. 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
