Search found 5 matches
- 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 ...
- 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...
- 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...
- 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...
- 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...