SQL. ExecNonQueryBatch (EventName As String) As ObjectAsynchronously executes a batch of non-query statements (such as INSERT).The NonQueryComplete event is raised after the statements are completed. You should call AddNonQueryToBatch one or more times before calling this method to add statements to the batch. Note that this method internally begins and ends a transaction. Returns an object that can be used as the sender filter for Wait For calls. Example: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000))) Next Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log("NonQuery: " & Success) B4A Question Unknown problem while using ExecNonQueryBatch, JdbcSQL [Solved] - Anser    Aug 24, 2023 a remote MySQL table.
I am using ExecNonQueryBatch to do a batch insert to remote MySQL server.
The problem that I am facing is that
I am not getting any error
ExecNonQueryBatch status is returning... B4A Tutorial [B4X] SQL with Wait For - Erel    May 15, 2017   (21 reactions)   tags: wait, Wait For, Resumable Sub, SQL Wait For progress web, SQL .ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log... will be caught by the correct Wait For call in all cases.
- Note that SQL.ExecNonQueryBatch begins... B4J Code Snippet jtds jdbc driver with standalone package - Erel    Aug 25, 2021   (11 reactions) .ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log("NonQuery: " & Success)
End Sub
If you get an error such as: "SSO...=test&password=test")
For i = 1 To 10
sql.AddNonQueryToBatch("INSERT....LoadLayout("Layout1")
MainForm.Show
Dim sql As SQL
sql.Initialize("net... B4A Tutorial SQL tutorial - Erel    Oct 2, 2019   (19 reactions)   tags: sqliteimages, begin transaction, SQL . Batch inserts SQL.AddNonQueryToBatch / ExecNonQueryBatch allow you to asynchronously process a batch...))) Next sql1.ExecNonQueryBatch("SQL") ... Sub SQL_NonQueryComplete (Success As Boolean... AddNonQueryToBatch and eventually call ExecNonQueryBatch. The task will be processed in the background... code: Sub CreateTables SQL1.ExecNonQuery("DROP TABLE IF EXISTS table1") SQL1.ExecNonQuery("DROP TABLE IF EXISTS table2") SQL1.ExecNonQuery("CREATE TABLE table1... Share My Creation User Login + MySQL PHP API - aeric    Apr 24, 2024   (31 reactions) Web API Updates: For B4J API Server and cross platform client apps, please check MySQL API Server (Key + Token) and User Login Apps https://www.b4x.com/android/forum/threads/b4j-mysql-api-server-key-token-and-b4x-user-login-apps.126081/ 94106 94119 94118 Android App 94107941089411194112 94109 102583 This is the 3rd version of login example I share in this forum. The first version... OKHttpUtils2 Both of the samples I shared are using very simple PHP with mysql_query function. I have later... Wish [Wish] SetNonQuery2Statement, AddNonQuery2Args, ExecNonQuery2Batch - OliverA    Apr 24, 2018   (3 reactions) AddNonQueryToBatch is such a case: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT INTO table1 VALUES (?)", Array(Rnd(0, 100000))) Next Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL...The current AddNonQueryToBatch/ExecNonQueryBatch is very flexible by allowing various non-query... of 1000 entries). The ExecNonQueryBatch then iterates over that list (https://github.com....AddNonQuery2Args(Array(Rnd(0, 100000))) Next Dim SenderFilter As Object = sql.ExecNonQuery2Batch... B4A Question SQLite, ExecNonQueryBatch with WaitFor; missing SQL_QueryComplete - leitor79 (first post)    Jul 27, 2017 Hi Erel, thank you for your answer.
I can't reproduce the error. I mean; I uncommented the section (which I've replaced with... B4A Question SQLite - trouble with ExecNonQueryBatch and SQL_NonQueryComplete - Erel (first post)    Dec 1, 2013 1. Code modules cannot handle events. DBUtils was written before the addition of classes. I recommend you to change DBUtils to a class. You will then be able to handle the events.
2.
If Cmd.Trim = &... B4A Question cloudKVS - how to identify specific changes on NewData event? - Erel (first post)    Sep 11, 2023 It is being a while since I've touched this code, but it looks like you can get the list of updated items at this point: 'ser_BytesToObject If items.Size > 0 Then For Each item1 As Item In items InsertItemIntoData(item1, True) Next sql.ExecNonQueryBatch("getuser") End If ... B4J Question How to execute SQLite dump list ? - aeric (first post)    Mar 24, 2023 I only can think to use the query batch run the commands one by one SQL.AddNonQueryToBatch(Query1, Null) SQL.AddNonQueryToBatch(Query2, Null) SQL.AddNonQueryToBatch(Query3, Null) Dim sf As Object = SQL.ExecNonQueryBatch("SQL") Wait For (sf) SQL_NonQueryComplete (Success As Boolean)... Page: 1   2   3   4   5   6   7   |