Nov 21, 2021 The modes are explained here: https://www.sqlite.org/pragma.html#pragma_journal_mode The two cases where it is important to set the journal mode: 1. WAL - B4J server solutions: https://www.b4x.com/android/forum/t...ent-access-to-sqlite-databases.39904/#content 2. DELETE - when it is important that the database will be made of a single file. Code: sql.ExecQuerySingleResult("PRAGMA journal_mode = delete") Log("Current mode: " & sql.ExecQuerySingleResult("PRAGMA journal_mode")) Click to expand...
The modes are explained here: https://www.sqlite.org/pragma.html#pragma_journal_mode The two cases where it is important to set the journal mode: 1. WAL - B4J server solutions: https://www.b4x.com/android/forum/t...ent-access-to-sqlite-databases.39904/#content 2. DELETE - when it is important that the database will be made of a single file. Code: sql.ExecQuerySingleResult("PRAGMA journal_mode = delete") Log("Current mode: " & sql.ExecQuerySingleResult("PRAGMA journal_mode"))
