B4J Question SQLite Transaction - ThRuST    Jan 23, 2019
SQLite with B4J? What about .TransactionSuccessful vs Commit?
The idea is to have these pasted..., data
' Inserts multiple items into SQLite database
Share My Creation Csv to SQLite program - klaus    Nov 1, 2022   (33 reactions)   tags: csv sql, Import, export
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.
Added the use of SQLite transaction, suggested by Diceman in post #6.
Added an exe file:
You need to unzip it to get...Attached you find a small project to convert csv files to a SQLite database.
B4A Question SQLite: preventing multiple calls to BeginTransaction - Didier9    May 22, 2021
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...
B4i Question Sqlite BeginTransaction error: database is locked - Erel (first post)    Aug 3, 2019
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....
B4A Question Behaviour With b4a 3.20 upgrade and Sqlite Transaction - Tommy h (first post)    Jan 21, 2014
Not sure whether you intended it or not..., thank you. I've solved managing transaction correctly....
B4A Question SQLite - Simultaneous transactions - gawie007 (first post)    Jan 16, 2014
Thanks for your valued support Erel,
I will open the DB from a couple of more suitable places if it ...
Italian [RISOLTO] [B4J] [SQLITE] caratteri strani in campo text di sqlite - ivanomonti    Mar 21, 2023
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...
B4J Tutorial [WebApp] Concurrent access to SQLite databases - Erel    Nov 21, 2021   (12 reactions)
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...
B4A Question Update queries for SQLite don't work with transactions? - isr (first post)    Nov 19, 2012
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...
B4A Question download mysql - edgar_ortiz (first post)    Oct 5, 2020
You can check:
I would start by removing the Begin - End transaction...
Page: 1   2   3   4   5   6   7