Search Results

The new resumable subs feature, introduced in B4J v5.50, B4i v4.00 and B4A v7.00 (to be soon released), makes it simpler to work with large data sets with minimum effect on the program responsiveness. The new standard way to insert data is: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT INTO
link: ExecNonQueryBatch doesn't report the progress. You can show a progress dialog: ProgressDialogShow2("Inserting data...", False) For i = 1 To 1000
link: Don't use msgbox to check the status. Use Log. If you do want to show a msgbox then call MsgboxAsync. For Each m As Map in L1 Starter.SQL.AddNonQue
link: Hi All, What am I doing wrong in this code? it return Success=False For i=0 To L1.Size-1 m=L1.get(i) Try mS

WHERE p3 = ?" sql3.AddNonQueryToBatch(query1, Array(m.Get("a"), m.Get("b"), m.Get("av"), m.Get("bv"), p)) sql3.AddNonQueryToBatch(query2, Array(m.Get("a"), m.Get("b"), m.Get("av"), m.Get("bv"), p)) sql3.AddNonQueryToBatch(query3, Array(m.Get("a"), m.Get("b"), m.Get("av"), m.G

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

Sometimes it is better and safer to use parameterized query. So instead of: SQL2.AddNonQueryToBatch("Insert Into masclis (codigo,nombre,nif,direccion,otro) Values ('123ED','','','','')",Null) Use: SQL2.AddNonQueryToBatch("Insert Into masclis (codigo,nombre,nif,direccion,otro) Values (?,?,?,?,?)", Ar
link: Sub Button1_Click Dim SQL2 As SQL SQL2.Initialize(DBFileDir,DBFileName,True) Log("0") Msgbox("0","") SQL2.ExecNonQuery("Dele

I spent quite a bit of time tracking down an error that... wasn't in my project. To prevent you from doing it too... I had to insert many records into an Access table. I used a transaction (BeginTransaction). The project produced no errors, but the table was empty. I also tried AddNonQueryToBatch
link: It just requires an additional call at the right place: sql.ExecNonQuery("COMMIT;") See: (Thanks to @jmon https://www.b4x.-and-ucanaccess.62909/post

Sub Activity_Create(FirstTime As Boolean) If FirstTime Then MySQLConnection.Initialize(MYSQLIP,MYSQLDBNAME,MYSQLUSER, MySQLPASS,MYSQLPORT) End If 'return query as cursor MySQLConnection.ExecQuery("query","select * from products") 'Batch updates into a transaction

If you need a push, it should be something like this, using string literals and parameterized query: Starter.mysql.AddNonQueryToBatch($"Insert into t_dpt(no_kk,no_nik,nama,kota_lahir,tgl_lahir, status_kawin,jenis_kelamin,alamat,no_rt,no_rw,kelurahan, kecamatan,kota,propinsi,no_tps,di
link: Hi, I'm trying to save a record that contain Blob data type but it always unsuccessful and I don't understand why, here's my code, maybe someone can h

DB.AddNonQueryToBatch(strSQL, Array(Application.VersionCode, DB_VERSION)) Dim SenderFilter As Object = DB.ExecNonQueryBatch("DB") Wait For (SenderFilter) DB_NonQueryComplete (Success As Boolean) Log("DB.ExecNonQueryBatch('DB'): " & Success) If Success Then

SQL1.AddNonQueryToBatch(strSQL, Array(row(0), row(1), row(2), row(3))) Next Dim SenderFilter As Object = SQL1.ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log("Data Insert: " & Success) Else

AddNonQueryToBatch is a great tool, but I wonder if it is necessary here (unless some sort of UI responsiveness is needed). The method adds the statement to an internal list and then ExecNonQueryBatch iterates over this list by calling ExecNonQuery2 for each statement in the list. This procedure is
link: my new variant of converttodb Sub converttodb Dim textrd As TextReader textrd.Initialize(File.OpenInput("Z:\","ticks.csv")) Dim line As
link: https://www.b4x.com/android/help/sql.html#sql_execnonquerybatch
link: Today i will try to set some xms.. parameters and see, if i can make it with only one use of ExecNonQueryBatch BTW: I just found a message, that i ha

Powered by ColBERT