Android Question ExecNonQueryBatch failing

gbzrope

Member
Licensed User
I have some code identical to the snippet below which works, but this part returns Fail

The query iteslf is fine if I run it directly against the mysql database using TOAD.


B4X:
sSQL="INSERT INTO vehicledailychecksheaders(Vehicle, ChargeHand, Date) VALUES (860, 11, '2019-03-
21')"

mysql.AddNonQueryToBatch(sSQL,Null)
Dim SenderFilter As Object = mysql.ExecNonQueryBatch("SQL")
Wait For (SenderFilter) SQL_NonQueryComplete (Success As Boolean)
Log("NonQuery: " & Success)
 

gbzrope

Member
Licensed User
Are you using JdbcSQL?

Yes, against a remote mysql database.

What is the output of Log(LastException) ?
<facepalm>

It is reporting an error with the sequel - a missing default value for a field not being sent.
I removed the field from the target table - it is not used, and it now works.


Thanks.
 
Top