SQLite Delphi Client/Server: changes not persisting in the database

Data Abstract
,
1

Hi,

Attached is a simple (or so I thought) demo application. First time I used SQLite as a back-end and the application is not saving any data.

Hit Load Data, make some changes in the top grid, press Save. Then hit refresh and the changes are gone.

Clearly I’m missing something really obvious… help :slight_smile:

Thanks
Stuart

DemoServerClient.zip (86.9 KB)

2

can you attach patients.db here or send it to support@, pls ?
by other hand, you can attach DDL script for creating this db

3

Sorry - here’s the project with the Patient.DB added.

DemoServerClient.zip (583.7 KB)

4

there is some problem with SQLite driver.
with Firedac driver it works as expected

5

Thanks, logged as bugs://79582

1 Like
6

Thanks (slightly relieved it’s not me being a dumbass) :grinning:

7

As I can see, Aducom SQLite can update data in databases with UTF-8 encoding only and cannot with other ones.
your database had UTF-16le encoding.
it seems to be the limitation of this driver.

1 Like
8

bugs://79582 got closed with status notfixable.