Search Results

https://www.b4x./?query=journal+sql Only for better code organization. Closing the SQL object while there is an ongoing async method will break the async method. Note that you don't really need to close the SQL object before making a backup.
link: Oh... there is a journal mode? How can one set that? Does it matter, in which Sub Process_Globals a variable is declared? At the moment it is declar
link: Make sure that the journal mode is not set to wal as the database will be made of three files. Better to put the global variable in the Starter servi

Both answers are correct. You should never make more than a single insert without an explicit transaction. Async SQL is very simple: SQL with Wait For

here is the async version: WriteLog("query start") Dim SenderFilter As Object = DB.ExecQueryAsync("SQL", "SELECT DISTINCT carvaluename FROM carvalues WHERE timestamp>=? AND timestamp<=? ORDER BY carvaluename", Array As String(starttimestamp, endtimestamp)) WriteLog("query end") Wait For (SenderFilt

i believe all that we have is an async query, not an async non-query (which is what an insert is). i looked at our sql library, and the async query is the only reference i saw. google does have an sqlite helper class which, i think, manages the potential conflict between db requests possibly timin

Tutorial about async SQL methods: SQL with Wait For
link: 1. It is a mistake to use the non-async methods with JdbcSQL. 2. Check the Success parameter. If it is true then the command was executed successfully

Use the async SQL methods. SQL with Wait For

A better option is to use the async methods: SQL with Wait For

Use the async SQL methods. Use jOkHttpUtils2. Everything is done in the background.

Have someone experienced with async methods in SQLCipher? For some reason they don't work in my project, this code returns a success = true sql.AddNonQueryToBatch($"INSERT OR REPLACE INTO ${table} VALUES(?, ?)"$,Array as String(Name,id)) Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL2") Wa
link: I've uploaded an update: https://www.b4x.com/android/files/SQLCipher.zip Please try it, it should fix this issue.
link: Still happens the same, is there an alternative way to asynchronously execute non queries?

I'm happy to release B4A v7.01. This update includes the new resumable subs feature. This is the most important programing language improvement since the addition of classes in B4A v2. It makes it much simpler to manage asynchronous tasks. Quoting @johndb : This version sure does clean up the code

Powered by ColBERT