Search Results

.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...
link: .ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log...
link: ("CustomerName"))) Next Dim SenderFilter As Object = Starter.SQL.ExecNonQueryBatch("SQL"...
link: Dim SenderFilter As Object = Starter.SQL.ExecNonQueryBatch("SQL") Wait For...

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...
link: it everytime. After connection is established then only add the query to the mysql object. Yes...
link: it everytime. After connection is established then only add the query to the mysql object....
link: the previous initialization. In the same activity, before calling this routine, I am connecting to MySQL...

.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...
link: .ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean...

. 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...

simple PHP with mysql_query function. I have later updated the 2nd sample with mysqli since mysql...

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...

, "password") Before executing the batch, you can try check if the database is initialized or opened. If MySQL.IsInitialized Then Dim SenderFilter As Object = MySQL.ExecNonQueryBatch("SQL") Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean) Log("NonQuery...Maybe you can try to use MySQL.InitializeAsync("sql", "com.mysql.jdbc.Driver"...
link: Sub RunMe Dim SenderFilter As Object = sql.ExecNonQueryBatch("SQL") Wait For...

Hi Erel, thank you for your answer. I can't reproduce the error. I mean; I uncommented the section (which I've replaced with...
link: Please post code and errors as text, not screenshots. Right click on the logs to copy them. The first code snippet looks correct. Pl...
link: it, I get an exception: 58121 As I see, "sql_querycomplete" is missing. It's odd since...

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 = &...
link: .ExecNonQueryBatch("SQL") End Sub ' NonQueryComplete is invoked...

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 ...