Search Results

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...

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...

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...
link: Are you sure you are committing the transactions? Do you have any sample code? Maybe this link will help you. https://sqlite.org/temp...
link: Hello all, A quick question on SQL -journal files. I have a program that uses very large SQL...

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...
link: These are temporary files but they are managed by the SQLite engine. The journal file is important...
link: Well, as it is defined as "Temporary" in the SQLlite doc, why is it still there? I seem to...
link: You shouldn't delete it. Why do want to remove it?...

Web API Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ Older project: https://www.b4x.com/android/forum/threads/b4j-mysql-api-server-key-token-and-b4x-user-login-apps.126081/ 94106 94119 94118 Android App 94107941089411194112 94109 102583 This is the 3rd version of login exam...

Updates: Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/ 105281 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 - Source code...

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...
link: /results/?query=journal+sql Does it matter, in which Sub Process_Globals a variable is declared...

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....

sql.ExecNonQuery("PRAGMA journal_mode = DELETE") It should be: rs = sql.ExecQuery("PRAGMA journal_mode = DELETE")...
link: Note that if SQL journal mode is 'wal', which is the default mode in newer versions...
link: Note that if SQL journal mode is 'wal', which is the default mode in newer versions...
link: over the ResultSet. Best to write it like this: sql.ExecQuerySingleResult("PRAGMA journal_mode...

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...