Search found 5 matches

by lfcap
20.11.2024, 10:38
Forum: ZeosLib 7.3/8.0 Forum
Topic: SQLite detach database produces database is locked error
Replies: 1
Views: 47

Re: SQLite detach database produces database is locked error

Hello, After several days of research, we found a workaround. I don't know if it is sustainable but it currently works with ZeosDb V8.0. Description: The problem comes from the fact that some Datasets opened on database 1 also cause database 2 to be locked even though all Datasets in database 2 are ...
by lfcap
18.10.2024, 18:28
Forum: ZeosLib 7.3/8.0 Forum
Topic: SQLite detach database produces database is locked error
Replies: 1
Views: 47

SQLite detach database produces database is locked error

Hello, I use attached databases with SQLite on my projects and it works well with Zeosdb 7.0 and 7.1. But it no longer works with Zeosdb 7.2 and 8.0. My need is to open a "master" database and attach another detail database among several available. We open only one detail database at a tim...
by lfcap
16.04.2020, 17:44
Forum: ZeosLib 7.2 Forum
Topic: SQLite Detach database error with TZConnection.ExecuteDirect
Replies: 0
Views: 505

SQLite Detach database error with TZConnection.ExecuteDirect

Hello and thank you to the ZeosLib team for your good work. I use Delphi XE5. I just migrated from ZeosDbo 7.0.6-stable to 7.2.6-stable. My program uses SQlite3 and attaches and detaches the bases with: TZConnection.ExecuteDirect ('Attach database "myBasefile.db3" as XXX ’) TZConnection.Ex...
by lfcap
13.12.2017, 10:31
Forum: ZeosLib 7.0 Stable Forum
Topic: Pb migration program with SQLite ANSI db from D2007 to XE4
Replies: 1
Views: 3846

Pb migration program with SQLite ANSI db from D2007 to XE4

Hello, I need to migrate ANSI application Delphi 2007 to Unicode XE4. The program store ANSI data into SQLite 3 file. The recompiled program with XE4 show incorrectly the read strings from db. The French accents are replaced by "?". Example with text "Préférence" (é = $E9) The XE...
by lfcap
25.11.2013, 11:37
Forum: ZeosLib 7.0 Stable Forum
Topic: 7.0.6 SQLite Query return erroneous blob field type
Replies: 1
Views: 2062

7.0.6 SQLite Query return erroneous blob field type

7.0.6 and SQLite 3: Query with multiple tables return erroneous blob field type For example, in my database I create 2 tables: T1 as 2 or more fields (F1 INTEGER, F2 BLOB, …) T2 as 2 or more fields (Fa INTEGER, Fb VARCHAR, …) With TZReadOnlyQuery or TZQuery if I set SQL text as “Select F1, F2 From T...