Android Question MSMySQL Library

[Andreas_D99]

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

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

 

[eps]

Do you not need a ";" appended to the end of the Delete statement?

e.g. from the library thread..

     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.

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

 

[Andreas_D99]

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...

 

[eps]

But ExecResult is simpling processing the event you've set up, no?

I'm sure that @DonManfred will be along soon to help out

ETA : Have you seen this? https://www.b4x.com/android/forum/threads/msmysql_deletehelper.57296/

 

[DonManfred]

Change the signature to

Sub MySQL_ExecResult(l As List, meta As Map)
    Log(meta)   
End Sub

but l would always be a empty but initialized list. Just ignore it...

 

[Andreas_D99]

Yesss... thats it...!