Android Question ExecNonQueryBatch failing

[gbzrope]

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.

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)

 

[Erel]

Are you using JdbcSQL?

What is the output of Log(LastException) ?

 

[gbzrope]

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.