Android Question An alternative for File.DirRootExternal ?

[vmag]

Hello. On newer versions of android, where you need to save a backup copy of SQLite instead of File.DirRootExternal ?

 

[Erel]

The available options are listed here: https://www.b4x.com/android/forum/t...list-of-other-related-methods.129897/#content

 

[vmag]

Thank you. I was looking at an example with saving txt to a selected folder, but I thought that copying an Sqlite file might be different from copying txt.

 

[Erel]

There is an important point related to SQLite dbs. You need to make sure that the journal mode is set to DELETE: https://www.b4x.com/android/forum/threads/b4x-sql-setting-the-journal-mode.136211/#content

 

[vmag]

There is an important point related to SQLite dbs

Thank you.
You have an amazing ability to answer questions that have not been asked...
I've been struggling with the SQLite database backup problem for a week now.
The backup always included an intermediate database, not the last one.
After reading the links, I fixed the flaws and now the copying is done correctly, the errors were as follows:
1. Each B4X page opened its own SQL (SQL1, SQL2, SQL3,...) with entries in different tables of the same database.
2. There was no option when creating the database:

Main.SQL1.ExecQuerySingleResult("PRAGMA journal_mode = delete")

Thanks again