s, etc). I've only ever run into database
locked issues is when my app is writing the data pretty quickly to the DB
and SQLite Expert runs a query. I'll get a timeout somewhere, but its
easily explained. Expanding the timeout on both applications usually fixes
the locked
t;>
>> - Original 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
&g
where? 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--
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
@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
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 that wr
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
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
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 cli
AL] 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
-20222-cn
- 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
red from a 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
AL] Re: 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 201
: 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
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 sqlite3 console
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 with
] [EXTERNAL] (no subject)
On 2018/08/10 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 Fire
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.
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 ma
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 NU
.VERBUM_ID =
Verbum.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
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)
);
C
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]
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
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
http://mailinglists.
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
erting ISO 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'
Betreff: Re: [sqlite] TEXT shows as (WID
: sqlite-users [mailto:sqlite-users-boun...@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 t
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;
>
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:
30 matches
Mail list logo