random lost data
Posted: Thu 11 Jul 2019 09:30
I am using Delphi XE6 with the latest mydac components on a MySQL 5.5.62-0ubuntu0.14.04.1
My invoice program is really simple with a head and an item table. (TMyConnection->TMyTable)
Sometimes the following problem occurs:
I enter data - everything is fine - I can scroll through my invoices, also the detail table shows the right data. Then I leave my program and re-enter. And the work of a day or so is lost. Like a cache is not wirtten properly to the disk. Within this time my MySQL server is always on - no restart or so. I can´t reproduce the error, the problem occurs randomly.
I checked many times that all table cachedupdates are set to false. What could be the reason for this behaviour? Maybe a problem with my MySQL configuration?
I don´t understand why I can browse through my invoices without any problem - where did this data come from and after closing the app the data is gone.
My invoice program is really simple with a head and an item table. (TMyConnection->TMyTable)
Sometimes the following problem occurs:
I enter data - everything is fine - I can scroll through my invoices, also the detail table shows the right data. Then I leave my program and re-enter. And the work of a day or so is lost. Like a cache is not wirtten properly to the disk. Within this time my MySQL server is always on - no restart or so. I can´t reproduce the error, the problem occurs randomly.
I checked many times that all table cachedupdates are set to false. What could be the reason for this behaviour? Maybe a problem with my MySQL configuration?
I don´t understand why I can browse through my invoices without any problem - where did this data come from and after closing the app the data is gone.