Android Question sqlLite journal

DPaul

Active Member
Licensed User
Longtime User
Hi,

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 :-(

thx,
paul
 

DPaul

Active Member
Licensed User
Longtime User
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.

Paul
 
Upvote 0

DPaul

Active Member
Licensed User
Longtime User
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 :)

But i bet purists would not approve.

Paul
 
Upvote 0
Top