B4A Code Snippet [B4X] SQL - setting the journal mode - Erel    Nov 21, 2021   (7 reactions) it is important that the database will be made of a single file. sql.ExecQuerySingleResult("PRAGMA journal_mode = delete") Log("Current mode: " & sql.ExecQuerySingleResult("PRAGMA journal_mode")) ...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... B4J Tutorial [WebApp] Concurrent access to SQLite databases - Erel    Nov 21, 2021   (14 reactions) set the journal mode to wal: sql.ExecQuerySingleResult("PRAGMA journal_mode = wal") You only need to set the journal mode to wal once. Read more about wal mode: https://www.sqlite.org/wal... such as MySQL and others. However they can still be perfect for small / medium solutions, especially if... databases. You need to follow these instructions: - Use a single SQL object that is shared by all.... B4J SQL library (when initialized with InitializeSQLite) will serialize writers access. - When... B4A Question SQL Journal Files - Erel (first post)    Oct 12, 2018 There is no reason for your SQL commands to block the main thread. Use the async methods instead. They are very simple to use: SQL with Wait For... B4A Question sqlLite journal - DPaul (first post)    Jan 5, 2017 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... Share My Creation User Login + MySQL PHP API - aeric    Jan 26, 2023   (31 reactions) Web API Updates: For B4J API Server and cross platform client apps, please check User Login App + MySQL API Server (Key + Token) https://www.b4x.com/android/forum/threads/b4x-user-login-app-b4j-mysql-api-server-key-token.126081/ 94106 94119 94118 Android App 94107941089411194112 94109 102583 This is the 3rd version of login example I share in this forum. The first version I shared when I started learning B4A is just a very simple login app. Http Login example using HttpUtils2... B4A Question How to replace a Sqlite db file in use by the app? - Erel (first post)    Mar 21, 2023   (2 reactions) 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.... B4A Question IllegalStateException: attempt to re-open an already-closed object - Creideiki (first post)    Feb 3, 2022
https://www.b4x.com/android/forum/pages/results/?query=journal+sql
Ok, sorry... and interesting. Though not for this project.
Closing the SQL object while there is an ongoing async method will break the async method.
Well... that's plausible. I'm quite sure that's not my problem.
Note that you don't really need to close the SQL object before making a backup.
Oh, really... B4A Question Replace SQLite DB with Backup from Web Server - Mahares (first post)    Nov 21, 2021   (3 reactions)
sql.ExecNonQuery("PRAGMA journal_mode = DELETE")
It should be:
rs = sql.ExecQuery("PRAGMA journal_mode = DELETE")... B4i Question sqlite - upload - Erel (first post)    Feb 16, 2023 Tip: set the journal mode to delete https://www.b4x.com/android/forum/threads/b4x-sql-setting-the-journal-mode.136211/#content... Share My Creation [B4X] User Login App + [B4J] MySQL API Server (Key + Token) - aeric    Aug 14, 2022   (35 reactions) Update: I recommend you to also take a look at my latest Web API Template if you want to develop B4X client apps connecting to MySQL/SQLite backend web server using JSON format API. Finally I would like to share my B4J API server written in B4J. Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API. SQL.zip - SQL script to create necessary database and tables in MySQL server. jAPI.zip - Source code for server app (B4J). B4A.zip... Page: 1   2   3   4   5   6   7   |