Android Question ExecNonQueryBatch failing

Discussion in 'Android Questions' started by gbzrope, May 15, 2019.

  1. gbzrope

    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.


    Code:
    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)
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    Are you using JdbcSQL?

    What is the output of Log(LastException) ?
     
  3. gbzrope

    gbzrope Member Licensed User

    <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.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice