vmag Active Member Apr 29, 2024 #1 Hello. On newer versions of android, where you need to save a backup copy of SQLite instead of File.DirRootExternal ?
Hello. On newer versions of android, where you need to save a backup copy of SQLite instead of File.DirRootExternal ?
Erel B4X founder Staff member Licensed User Longtime User Apr 30, 2024 #2 The available options are listed here: https://www.b4x.com/android/forum/t...list-of-other-related-methods.129897/#content Upvote 0
The available options are listed here: https://www.b4x.com/android/forum/t...list-of-other-related-methods.129897/#content
vmag Active Member Apr 30, 2024 #3 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. Upvote 0
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 B4X founder Staff member Licensed User Longtime User Apr 30, 2024 #4 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 Upvote 0
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 Active Member Apr 30, 2024 #5 Erel said: There is an important point related to SQLite dbs Click to expand... 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: B4X: Main.SQL1.ExecQuerySingleResult("PRAGMA journal_mode = delete") Thanks again Upvote 0
Erel said: There is an important point related to SQLite dbs Click to expand... 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: B4X: Main.SQL1.ExecQuerySingleResult("PRAGMA journal_mode = delete") Thanks again
