Android Question How to replace a Sqlite db file in use by the app?

[amorosik]

I have a B4A procedure that uses a Sqlite db to store information
I would like to allow the program to read from another location (via ftp/http ...) the entire file containing the new db to be used and put it in the location where the db currently used by the program is
Basically my PIPPO app which is using the PIPPO1.DB db when the db update command is given will download the new PIPPO2.DB from another location and will have to replace it with the current db, overwriting the old one
How to reach the current db location by overwriting the original PIPPO1.DB db?

 

[Erel]

1. make sure that the journal mode is "delete": https://www.b4x.com/android/forum/threads/b4x-sql-setting-the-journal-mode.136211/#content
2. close SQL. Replace the file and initialize it again.