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
Cookies are required to use this site. You must accept them to continue using the site. Learn more…