Android Question UPDATE remote MySQL table with RDC

[Declan]

I am attempting to UPDATE fields of a remote MySQL database table.
On my server side (RDC-Server) I have:

sql.update_onhandarea1=UPDATE onhandarea1 SET onhandprev =?,sales =?,sealedunits =?,onhandnow =?,date =? WHERE barcode= ?

This is called from my app, as so:

Sub UpdateRDCOnHandArea(area As String, barcode As String, onhandprev As String, sales As String, sealedunits As String, onhandnow As String,date As String)
'    ProgressDialogShow("SYNCHRONISING DATABASE")
    Dim cmd As DBCommand
    cmd.Initialize
    cmd.Name = "update_onhandarea1" & area
    cmd.Parameters = Array As Object(onhandprev,sales,sealedunits,onhandnow,date,barcode)
    reqManager.ExecuteQuery(cmd, 0, "onhandarea1" & area)
End Sub

However, I keep getting the following error:

UpdateRecord: UPDATE [onhandarea1] SET [onhandprev] = ? WHERE [barcode] = ?
UpdateRecord: UPDATE [onhandarea1] SET [sales] = ? WHERE [barcode] = ?
UpdateRecord: UPDATE [onhandarea1] SET [sealedunits] = ? WHERE [barcode] = ?
UpdateRecord: UPDATE [onhandarea1] SET [onhandnow] = ? WHERE [barcode] = ?
UpdateRecord: UPDATE [onhandarea1] SET [date] = ? WHERE [barcode] = ?
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
Error: Server Error
dbrequestmanager_handlejob (B4A line: 186)
Dim In As InputStream = Job.GetInputStream
java.io.FileNotFoundException: /data/data/b4a.example/cache/4: open failed: ENOENT (No such file or directory)
    at libcore.io.IoBridge.open(IoBridge.java:496)
    at java.io.FileInputStream.<init>(FileInputStream.java:76)
    at anywheresoftware.b4a.objects.streams.File.OpenInput(File.java:209)
    at anywheresoftware.b4a.samples.httputils2.httpjob._getinputstream(httpjob.java:128)
    at b4a.example.dbrequestmanager._handlejob(dbrequestmanager.java:345)
    at b4a.example.main._jobdone(main.java:2228)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:187)
    at anywheresoftware.b4a.keywords.Common$5.run(Common.java:981)
    at android.os.Handler.handleCallback(Handler.java:815)
    at android.os.Handler.dispatchMessage(Handler.java:104)
    at android.os.Looper.loop(Looper.java:194)
    at android.app.ActivityThread.main(ActivityThread.java:5624)
    at java.lang.reflect.Method.invoke(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:372)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:959)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:754)
Caused by: android.system.ErrnoException: open failed: ENOENT (No such file or directory)
    at libcore.io.Posix.open(Native Method)
    at libcore.io.BlockGuardOs.open(BlockGuardOs.java:186)
    at libcore.io.IoBridge.open(IoBridge.java:482)
    ... 17 more

I have checked, and rechecked, but cannot find the promlemo

 

[mc73]

I think that you should use executeCommand instead of executeQuery.

 

[Declan]

@mc73, thanks - that was it