Search Results

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 the exe file. Unfortunately the exe file is not accepted by my McAfee anti virus prog
link: Hi Diceman. I saw your post only today, do not know why I missed it. I added your suggestion to use SQLite transaction. Yes the program is now very f
link: Last week i found a wonderfull program, which is able to connect and migrate all most used databases against another; its include Access, Excel, dBase

Sqlite isn't designed to be a multi-user/thread database. You might try moving your begin transaction statement down to where you actually start writing and see if that helps. To avoid issues like this I generally I have a single SqliteManager class that handles all of the I/O requests sequential
link: The idea is good, but my application is too complex (and used by many) to completely rewrite. Anyway, I opened two new sql objects but that didn't hel
link: Size) As String di = 0 sb.Append("SELECT count(*) FROM ").Append(realtabla).Append(" WHERE ")

The above code took less than half a second to run on a real device. Without the BeginTransaction / EndTransaction block it took about 70 seconds. A transaction block can also be used to guarantee that a set of changes were successfully done. Either all changes are made or none are made. By calling
link: a question, how can you use the SQL date when I table the date type are not available, and when it is necessary to add to the list and put it as Array

rraswisak Many thanks for your working example. For me it was a great tutorial on SQL and I was correct, my first attempts to use your suggestions screwed up the syntax. Working examples are the best teachers, I now have a little bit better understanding of SQL although I don't know what/why the
link: no problem, glad that this solution works for you. When your app dealing with database and had to do some query (CRUD) operation to many table it's b
link: Hi All, The preceding "discussion" has been an education for me. As such I tried the RBS one line solution, replacing three lines of code in my Sub.
link: this query work with other case which is a table has column with unique value inside (say, primary or auto_increment value). As in your sql sample ro

Did you use the transactions? The use of transactions increases performance (in sqlite DB). SQL.BeginTransaction ''Start insert loop SQL.ExecNonQuery("your insert into.....") ''End insert loop SQL.TransactionSuccessful
link: It will be 100 times faster if you create a single transaction. Or better: SQL with Wait For
link: Hi, i removed the two ProgressDialogs, because they did work for me and added SQL1.BeginTransaction For i = 0 To L.size-1 Dim str() As String
link: try to replace AddNonQueryToBatch with ExecNonQuery2: SQL1.BeginTransaction For i = 0 To L.size-1 Dim str() As String = Regex.split(",",l.Ge

If you only need to make a single change then you can let the SQL engine start and close the transaction for you. In this case there is no reason not to include all of them in a single transaction (though your code is also fine).
link: 1. No need to write Array As Object. Array is enough. 2. Why not create a single transaction here? Overall it looks correct.
link: WHERE id=?",Array As Object(myString1, 1)) SQLiteCon.ExecNonQuery2("UPDATE myTable SET myRecord=? WHERE id=?",Array As Object(myString2, 2)) SQLiteCon
link: Thanks I will make the neccessary corrections. I'm not sure I understand this

Sounds to me that you are making things much more complicated than they need to be. Why it is important? SQL.TransactionSuccessful commits the transaction. The project is too large for me to help you. If you think that there is an issue then create small project that demonstrates it. Do remember
link: WHERE fullPath = ?"$ sqlRecent.BeginTransaction Try sqlRecent.ExecNonQuery2(qryStr, Array As String(dateStr,
link: Hi Erel, I am a bit of a database fiend. I love em! I jdon't like having journals hanging around. It's not good practice in my view. As has happene

What about: sql.AddNonQueryToBatch(. FIrst result in this search: https://www.b4x./?query=AddNonQueryToBatch It has a built in begin/end transaction. After you first click the Button, immediately have: btn.enable =false, then when the transaction is successful and complete. enable the button: btn.e
link: 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 a
link: My first thought was to set a tag on the button when clicked and unset it when the transaction is completed. Check the tag when clicked before perfor

Financial Mobile App 155624 Just $10.9 - Paypal: abdullcadre@gmail.com Financial Mobile App is a mobile application developed in B4X for Android that allows users to create and manage financial cards. With this app, users can create cards, manage transactions, and customize profile settings and cur

Also - I notice you are doing a sql.BeginTransaction But there is no corresponding TransactionSuccessful or EndTransaction. You don't need to run a transaction on a single SELECT query anyway & I don't even know if it would work - but if it does, then your SELECT will fail because you haven't go

Powered by ColBERT