Android Question JDBC MySQL

[gbzrope]

Is there any way to validate that an INSERT query was succesfull on a remote MySQL database?
Other than to then run another query to retrieve the recordset created?

e.g.

sSQL="INSERT INTO statements_collected(ID, Client, DeviceID) VALUES(" & Crsr.getint("ID") & "," & Main.iUserID & ",'" & MainOptions.sDeviceID & "')"
                    mysql.ExecNonQuery(sSQL)

 

[Erel]

1. It is a mistake to use the non-async methods with JdbcSQL.
2. Check the Success parameter. If it is true then the command was executed successfully.

 

[gbzrope]

1. It is a mistake to use the non-async methods with JdbcSQL.
2. Check the Success parameter. If it is true then the command was executed successfully.

I tried ExecQueryAsync but that expects a recordset, this is just an Insert query, and ExecQueryAsync does not work.

 

[DonManfred]

https://www.b4x.com/android/help/jdbcsql.html#jdbcsql_execnonquerybatch

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)

 

[gbzrope]

https://www.b4x.com/android/help/jdbcsql.html#jdbcsql_execnonquerybatch

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)

Yes, I have that file, the problem is/was that the queries are quite large and I have already built them up with values.
I have just tried:
sql.AddNonQueryToBatch(sSQL, NULL)
Which seems to work.

 

[DonManfred]

ExecNonQueryBatch is async... All ok

 

[Erel]

Tutorial about async SQL methods: [B4X] SQL with Wait For