SQLite sometimes doens't INSERT into database

[ChrisW67]

If you put the insert into a transaction and then commit it everything should be written to disc. Do you still get lost data?

[pag]

On some operating systems (windows) I have found that the commit will fail (leaving a journal file) if any of your sql statements are still active. It is necessary to use the clear() function on all active sql statements before the commit.