Each time the app creates a database, it also creates a "-journal" file.
When i read stuff about sqlLite, it says that the "-journal" file
is temporary, but even when i close the db and the app properly,
the journal remains.
Does b4a support a native command that deletes this file, or should i dive
into this "PRAGMA...." commands stuff.
I could also delete it programatically, but that is ugly :-(
Well, as it is defined as "Temporary" in the SQLlite doc, why is it still there?
I seem to have no use for it, but it may be that the system does without me knowing
The real reason is, that the user can select amongst historical databases, with data he entered before. (openFileDialog)
I do set the filter to "mydatabase.FileFilter = ".db" , but that also shows everything "beginning with" db, and that is somewhat confusing.
Mmmmmm....
Or i could filter to "mydatabase.FileFilter = ".db-journal", that way i see no duplicates either.
And a quick regex.replace in the "chosenname" also does the trick