Search Results

SQLite with B4J? What about .TransactionSuccessful vs Commit? The idea is to have these pasted..., data ' Inserts multiple items into SQLite database SQLiteCon.BeginTransaction SQLiteCon...
link: Transactions are good for multiple changes (speed) and if you have a logical unit of work. Example...
link: Well someone adviced me to only use transaction for multiple calls and not needed for single ones...
link: I assume you meant why I didn't use Transaction for all of them? Well someone adviced me to...

. The CsvToSQLiteExe file is still the old file, a new file with Java 11 is too big. I left also the previous version zip file. EDIT: 2021.09.18 Added the use of SQLite transaction, suggested by Diceman in post #6. EDIT: 2021.01.29 Added an exe file: CsvToSQLiteExe.zip You need to unzip it to get...Attached you find a small project to convert csv files to a SQLite database. The program: - detects...
link: use SQLite transaction. Yes the program is now very fast. The project has been updated to version 1.2...

I have a button which updates an SQLite database using BeginTransaction and EndTransaction. This phone is slow and it is easy to click on the button again before the previous transaction is complete...
link: What about: sql.AddNonQueryToBatch(. FIrst result in this search: That's the correct answer....
link: /forum/pages/results/?query=AddNonQueryToBatch It has a built in begin/end transaction. After you first...
link: /end transaction. After you first click the Button, immediately have: btn.enable =false, then when...

it's correct like this? Not at all. 1. Use the same SQL object in all pages. 2. Never call BeginTransaction unless you want to immediately make changes and always close it when done....
link: , "datos.db",True) s.BeginTransaction end sub 'OTHER PAGE- DETAIL Public Sub...
link: Hi erel thanks for answering if I use s.BeginTransaction but I also get the same error. I do not...
link: Do you call SQL.BeginTransaction anywhere in your code? Do you later close the transaction? Does...

http://www.sqlite.org/lang_transaction.html Not sure whether you intended it or not..., thank you. I've solved managing transaction correctly....
link: http://www.sqlite.org/lang_transaction.html "Transactions can be deferred, immediate, or...
link: Please read my answer again: Maybe you haven't read my answer Ok, no problem, I will do it. Tha...
link: . You should fix the code to properly start and close transactions....

Thanks for your valued support Erel, I will open the DB from a couple of more suitable places if it ...
link: Would it be safe NOT to close the db? Yes. The file will be closed when the process is killed....
link: Small tip: it is more elegant and safer to make this check in the init sub. Hi Erel, I have a few A...
link: Small tip: it is more elegant and safer to make this check in the init sub....

sqlite va da bene e senza errori, quando la genero e la esprimo con If sqliteInsert(query) = True Then addListView(values(1),values(0),respose) End If private Sub sqliteInsert(query As String) As Boolean Dim dataSqlite As SQL dataSqlite.InitializeSQLite(File.DirApp,"miasmart.db",False) dataSqlite.BeginTransaction Try dataSqlite.ExecNonQuery(query) dataSqlite.TransactionSuccessful Catch Log(LastException.Message...

SQLite databases are very easy to use as they don't require any additional software or configuration. SQLite support for concurrent access is not comparable to server based databases... there aren't many writings (ExecNonQuery). B4J v2.00 adds support for concurrent access to SQLite... classes. Don't use a ConnectionPool with SQLite database. - When you create the database you need to...
link: Explicitly creating transaction is not required in both server apps and desktop apps as SQLite...

Thank you, Klaus and Erel. Adding "TransactionSuccessful" makes everything execute... it. Despite the successful transaction, however, it still takes a long time for the update...
link: See the example code here: Basic4android - SQL...
link: You need to add : SQL.TransactionSuccessful SQL.BeginTransaction number =55555 For i=1 To 10 If...
link: . I have followed Erel's recommendation to use BeginTransaction and EndTransaction for all...

You can check: https://www.b4x.com/android/forum/threads/behaviour-with-b4a-3-20-upgrade-and-sqlite-transaction.36818/#content I would start by removing the Begin - End transaction...
link: -sqlite-transaction.36818/#content I would start by removing the Begin - End transaction...