Android Question MSMySQL Library

Andreas_D99

Member
Licensed User
I delete a Recordset ( will be deleted! ) an try to refresh with the Function
"MySQL_ExecResult", but this Error is occurred by raising:

upload_2017-3-20_16-55-30.png


B4X:
Sub MySQL_ExecResult(meta As Map)
'Dim m As Map = meta
' no matter wich Code is here, always the same Error... also with no Code... so where is the Problem... ?? :-O
     
End Sub


Sub ViewTable_CellClick(Col As Int, Row As Int)
Dim result As Int
result = Msgbox2("Delete Recordset ?", "Delete, "Yes", "", "No", Null)
       If result = DialogResponse.POSITIVE Then
           'If Yes...roast it
           Main.db.ExecuteASync("DELETE FROM t_abrechnung WHERE ID = " & myID, "Delete")
      End If
End Sub
 

Attachments

  • upload_2017-3-20_16-55-39.png
    upload_2017-3-20_16-55-39.png
    5.7 KB · Views: 225

eps

Expert
Licensed User
Longtime User
Do you not need a ";" appended to the end of the Delete statement?

e.g. from the library thread..

B4X:
     cSql = "SELECT user_id,username FROM users WHERE username = '"&cUserName&"' AND password = '"&cPassword&"';"

and Do you need the "Delete" second parameter? This is probably the reason for the signature error you are getting as it's just (I think) expecting a single parameter - I haven't used the library tho, so could be wrong - just going on the documentation available on the thread for the library

e.g.

B4X:
      db.executeasync("INSERT INTO b4alog SET log_value='Test"&i&"', log_time="&DateTime.Now&";")
 
Upvote 0

Andreas_D99

Member
Licensed User
this should not be the Problem...
I let the Sub "MySQL_ExecResult" totally empty, but the shown Error occurred...
If I remove the Sub "MySQL_ExecResult" completely, there is no Error, but also no
possibility to refresh the Recordset...
 
Upvote 0
Top