In CMD I can write to my database without problems. Can you give me a hint about what might be wrong with my OS-setup in Windows 10? Thank you for the answer and your help! Much appreciated!
Best Regards Lars -----Oprindelig meddelelse----- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Hick Gunter Sendt: 10. august 2018 11:55 Til: 'SQLite mailing list' Emne: Re: [sqlite] [EXTERNAL] (no subject) 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users