Search found 3 matches
- 16.04.2020, 17:44
- Forum: ZeosLib 7.2 Forum
- Topic: SQLite Detach database error with TZConnection.ExecuteDirect
- Replies: 0
- Views: 464
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: 3809
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: 2031
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...