I am try to UPDATE I get no error and the data don't change
are any example how to INSERT, UPDATE using jdbcSQL and MYSQL
B4X:
Dim sf As Object = Starter.mysql.ExecQueryAsync("mysql","UPDATE testtable SET id=?,name=? ,address=? WHERE id=? ", _
Array As Object("","name","address","1", Null))
Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)
Dim sf As Object = Starter.mysql.ExecQueryAsync("mysql","UPDATE testtable SET id=?,name=? ,address=? WHERE id=? ", _ Array As Object("","name","address","1", Null))
If Starter.mysql.IsInitialized = False Then
Wait For (CallSub(Starter,"Connect")) Complete (Success As Boolean)
If Success Then
Log("Connected")
End If
Else
Log("No")
End If
Dim sf As Object = Starter.mysql.ExecQueryAsync("mysql","UPDATE testtable SET name=? ,address=? WHERE id=? ", Array As Object("name1","address1","1"))
Wait For (sf) mysql_QueryComplete (Success As Boolean, Crsr As JdbcResultSet)
If Success Then
Log("1")
Else
Log("2")
End If
Oh my god....I suggest to learn the basics.. You have two opening "(" but only one closing ")"
Add a ) at the end.
Expect this my last answer.
Last Note: REMOVE the null in your parameters! You have 3 questionsmarks (?) but you give FOUR parameters. I already fixed this problem above.
Your query was ok in #3. But now you added null again. Why?