I have not yet seen any good reason to believe that your Delphi app and whatever trusty tool you use to independently view/alter the database are both accessing the same file. Because of the way SQLite auto-creates the DB file if it does not exist, such file discordance is a problem we often see here. And your initial post showed the symptoms of it. That is why Simon, Ryan and I have suggested measures to ensure you are not suffering that problem. Yet, instead of either seeing that issue resolved or enough clues to show that is not your issue, we keep seeing various workaround attempts based on hypothetical issues for which no evidence has appeared in this thread. It makes for a very disjointed joint troubleshooting effort, bordering on hopeless.