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: Klaus, Very nice utility. :) As a suggestion (no rush) you might want to wrap the table inserts in a transaction (with Try/Catch block) because it

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: e.g: '{"success":1,"products":'{"id":1,"ceg_id":61,"bolt_id":61,"cikkcsop_id":1,"cikkszam":"1011","megnevezes":"Piros alma","vtszkodtip":"VTSZ","vtsz"

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

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

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

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

Hi SQL1.TransactionSuccessful - commits the transaction and ends it. Do not forget to SQL1.close to release the pool connection otherwise it will cause memory leaks for you. Regards John.
link: use this : SQL1.TransactionSuccessful
link: Has EndTransaction been removed from Connection class? Dim sql1 As SQL = Main.pool.GetConnection SQL1.BeginTransaction 'no problem , BeginTransactio

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

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

@Erel you are rigth, but when export schema from "DB Browser" sql file is like this: BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "demo" ( "id" INTEGER, "field1" TEXT ); COMMIT; CREATE TABLE ..... ..... .... ; COMMIT; on first line there is BEGIN TRANSACTION; and on last line COMMI
link: At first, I pulled those lines out and ran the appropriate command: if cmd = "BEGIN TRANSACTION;" then sql1.BeginTransaction and same for commi
link: Never call ExecNonQuery multiple times without explicitly creating a transaction. Best option, which is very very simple, is to use the async batch m
link: Append(next_char) End If i=i+1 Loop End If Return cmdList End Sub 'here is an example function making use of

Powered by ColBERT