Close SQLite file
Posted: Tue 28 Aug 2012 10:28
Hello,
in our current project we're using SQLite (for the first time). So we run into a little problem: How can we close the database-file at runtime.
Background: The program connects to this file at startup. In the settings you can delete the database. But the delete-command fails, because UniConnection seems to lock the file or whatever.
We tried a simple
But the file is still open and not deletable.
How can we close the file?
Thanks in advance
in our current project we're using SQLite (for the first time). So we run into a little problem: How can we close the database-file at runtime.
Background: The program connects to this file at startup. In the settings you can delete the database. But the delete-command fails, because UniConnection seems to lock the file or whatever.
We tried a simple
Code: Select all
UniQuery1.Close;
UniConnection1.Disconnect;
UniConnection1.Close;
How can we close the file?
Thanks in advance