Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

but its easily explained. Expanding the timeout on both applications usually fixes the locked issue. On Fri, Oct 12, 2018 at 1:20 PM Lars Frederiksen wrote: > Thank you for your response. To answer your questions: > ___ sqlite-u

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

ginal Message - >> From: R Smith >> To: sqlite-users@mailinglists.sqlite.org < >> sqlite-users@mailinglists.sqlite.org> >> Sent: Friday, October 12, 2018, 17:35:28 >> Subject: [sqlite] error message: [FireDAC][Phys][SQLite] Database is >> locked >> &g

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

? Sometimes applications are picky when it comes where files are being written to (IE: Program Files). On Fri, Oct 12, 2018 at 8:30 AM Lars Frederiksen wrote: > Setting the Busy Timeout (in FireDAC) to 5000 ms does not solve the > problem - unfortunately! > > -Oprindelig meddelelse- &

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Database Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Change the timeout value on the connection to 5 seconds or so. The DB will retry. The AV has its grip on it, doing a scan, and won't let anything else touch it until its done. On Fri, Oct 12, 2018 at 3:11 AM Lars

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

@mailinglists.sqlite.org Emne: Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked Try to change database name (extension). For example: mydb.sqlite mydb.sdb mydb.db3 I would use .sqlite extension and exclude that files from antivirus check. Regards Lars Frederiksen je 12.10.2018 ob

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

is locked Try to change database name (extension). For example: mydb.sqlite mydb.sdb mydb.db3 I would use .sqlite extension and exclude that files from antivirus check. Regards Lars Frederiksen je 12.10.2018 ob 9:11 napisal: > Hello, > > I have made (in Delphi) a program th

[sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

Hello, I have made (in Delphi) a program that writes to a sqlite database. This is a simple stand-alone solution. Now something is blocking for the programs attempt to writing to the databse. There is a an error message: [FireDAC][Phys][SQLite] Database is locked. A friend of mine has analysed

[sqlite] Database locked problem

Hello, Delphi 10.2 - FireDAC - SQLite FDConnection1 - FDQuery - DataSource - DBGrid My DBGrid is is Showing words ("gloser") from my database with SQL = 'SELECT * FROM Gloser'. BUT When I fill out som editfields and want to append the data I get the error message: Database Locked

[sqlite] How to get RecNo when clicking on a DBGrid?

Hello, I am using Delphi and FireDAC. I have som editfields in the upper region of a tabsheet and a DBGrid in the lower part. When I click on my DBGrid I would like to write the fields from the choosen Record to the editfields. I wonder if it is possible to get the RecNo of a record when

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

TERNAL] Re: No unicode characters in sqlite3 console prg On 13 Aug 2018, at 1:45pm, Lars Frederiksen wrote: > This is the result: > > sqlite> Select GRAESK, hex(GRAESK), DANSK from gloser; > taß???a ?|CF84CEB1CEB2CEADCF81CEBDCEB120CEB7|taverna "taverna" in greek should be &q

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

- iso-2022-cn-ext While your console is probably expecting either a windows or an incompatible ISO encoding. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:46 An: 'SQLi

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

source the encodes in ISO. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:24 An: 'SQLite mailing list' Betreff: Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console

Re: [sqlite] [EXTERNAL] Re: No unicode characters in sqlite3 console prg

: No unicode characters in sqlite3 console prg You need to show hex() before anyone can verify what encoding is stored. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 13. August 2018 14:03

Re: [sqlite] No unicode characters in sqlite3 console prg

: Re: [sqlite] No unicode characters in sqlite3 console prg On 13 Aug 2018, at 1:03pm, Lars Frederiksen wrote: > I use versio 3.19 What operating system ? If you are using Windows, please issue this command before using sqlite3.exe: chcp 65001 Si

Re: [sqlite] No unicode characters in sqlite3 console prg

f Rowan Worth Sendt: 13. august 2018 03:21 Til: SQLite mailing list Emne: Re: [sqlite] No unicode characters in sqlite3 console prg On 12 August 2018 at 00:51, Lars Frederiksen wrote: > Is this an error of my windows 10 cmd prompt or is it a general problem > that > the sqlite

[sqlite] No unicode characters in sqlite3 console prg

Hello, Is this an error of my windows 10 cmd prompt or is it a general problem that the sqlite3 console is not able to show unicode in the cmd-window.?? No problem writing to the database and show (greek) unicode characters in the cmd prompt as I key them, but when I want to show the data

Re: [sqlite] [EXTERNAL] (no subject)

12:07 PM, Lars Frederiksen wrote: > 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! Usually the FireDAC connections work fine out the box, e

Re: [sqlite] [EXTERNAL] (no subject)

lite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af R Smith Sendt: 10. august 2018 20:06 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] [EXTERNAL] (no subject) On 2018/08/10 12:07 PM, Lars Frederiksen wrote: > In CMD I can write to my database without problems.

Re: [sqlite] [EXTERNAL] (no subject)

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' Betreff

[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

Re: [sqlite] Error trying to do inner joins

.VERBUM_ID -Original Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Lars Frederiksen Sent: Thursday, August 17, 2017 2:54 PM To: sqlite-users@mailinglists.sqlite.org Subject: [sqlite] Error trying to do inner joins Hello, I have a small db wit

[sqlite] Error trying to do inner joins

Hello, I have a small db with 3 tables: CREATE TABLE IF NOT EXISTS "Verb_Saetn"( VS_ID INT PRIMARY KEY NOT NULL, VERBUM_ID INT NOT NULL, SAETNING_ID INT NOT NULL, FOREIGN KEY(VERBUM_ID) REFERENCES Verbum(VERBUM_ID), FOREIGN KEY(SAETNING_ID) REFERENCES Saetning(SAETNING_ID) );

Re: [sqlite] Tutorials, books, video about SQLite

Thank you for all your advices concerning books about SQLite. I will have a closer look! Lars -Oprindelig meddelelse- Fra: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] På vegne af Nico Williams Sendt: 9. august 2017 22:19 Til: SQLite mailing list Emne: Re:

[sqlite] Mailinglist question

Hi Is it possible to read the mails directly on a server instead of receiving the mails constantly? Regards Lars ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Tutorials, books, video about SQLite

Hi I would appreciate very much if you clever people out there have some booktitles or links to tutorials (websites, video etc) about SQLite. Regards Lars ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] [FirDAC][Phys][SQLite]ERROR: Cipher: DB is not encrypted

Hi, I have added my SQLite database to DataExplorer in Delphi 10.1. I get this Errormessage [FirDAC][Phys][SQLite]ERROR: Cipher: DB is not encrypted When double click on some of the nodes or if I try to refresh the node of my database. My Encrypt property in the FDConnection Editor

Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid

to UTF8 somewhere along the way. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Lars Frederiksen Gesendet: Montag, 07. August 2017 10:39 An: 'SQLite mailing list' <sqlite-users@mailinglists.sqlite.org> Betreff: Re: [

Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid

...@mailinglists.sqlite.org] På vegne af Clemens Ladisch Sendt: 7. august 2017 10:28 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid Lars Frederiksen wrote: > I have followed 2 tutorials about SQLite, and none of these mentioned the > VARCHAR() possi

Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid

af Clemens Ladisch Sendt: 7. august 2017 08:33 Til: sqlite-users@mailinglists.sqlite.org Emne: Re: [sqlite] TEXT shows as (WIDEMEMO) in DBGrid Lars Frederiksen wrote: > CREATE TABLE gms( > gms_id INTEGER PRIMARY KEY, > gms_verb TEXT NOT NULL > ); > > FDTable1.Append; >

[sqlite] TEXT shows as (WIDEMEMO) in DBGrid

Hi, I am using Delphi 10.1 and I am trying to learn how to handle FireDAC with SQLite as a database. Beeing used to ADO and Access I find the learning curve a bit steep! My simple project: I have build a simple SQLite database with only 2 fields: a primary key integer and a text field, like this: