Android Question error with my mysql function

[gerredtor]

Hello i become an error with the code:

str.getString(3,speak)

speak is 1

Sub Class_Globals
    Dim sql As mysql   
End Sub

Public Sub Initialize
    sql.Initialize("tracks")
End Sub

Public Sub getString(id As Int, s As String) As String   
    s = sql.my_sql_load_wert("strings", "stringID", 2, "text", "AND `speakID`='" & s & "'")
       
    If s == Null Or s == "" Or s.EqualsIgnoreCase("") Then
        s = sql.my_sql_load_wert("strings", "stringID", id, "text", "AND `speakID`='2'")
    End If
   
    Return s
End Sub

Public Sub getStringReplace(id As Int, s As String, w1 As String, w2 As String) As String
    Dim s As String = getString(id, s)
   
    Return s.Replace(w1,w2)
End Sub

and the function my_sql_load_wert:

Public Sub my_sql_load_wert(table As String, index As String, indexwert As String, suche As String, zusatz As String) As String
    Dim rs As Cursor
    rs = sql.ExecQuery("SELECT * FROM `" & table & "` WHERE `" & index & "`='" & indexwert & "' " & zusatz)
   
    Dim a As String
   
    For i = 0 To rs.RowCount - 1
        rs.Position = 0
           a = rs.GetString(suche)
    Next
    rs.Close
   
   
    Return a
End Sub

and the error:

Error occurred on line: 10 (Strings)
java.lang.NullPointerException: expected receiver of type anywheresoftware.b4a.B4AClass$ImplB4AClass, but got null
    at java.lang.reflect.Field.getField(Native Method)
    at java.lang.reflect.Field.get(Field.java:266)
    at anywheresoftware.b4a.shell.Shell.getField(Shell.java:666)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:348)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:246)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:515)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:134)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
    at anywheresoftware.b4a.debug.Debug.delegate(Debug.java:262)
    at de.example.app.main._setuphamburger(main.java:1744)
    at de.example.app.main._hamburger_img_click(main.java:1736)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:515)
    at anywheresoftware.b4a.shell.Shell.runMethod(Shell.java:697)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:339)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:246)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:515)
    at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:134)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:78)
    at android.view.View.performClick(View.java:4438)
    at android.view.View$PerformClick.run(View.java:18422)
    at android.os.Handler.handleCallback(Handler.java:733)
    at android.os.Handler.dispatchMessage(Handler.java:95)
    at android.os.Looper.loop(Looper.java:136)
    at android.app.ActivityThread.main(ActivityThread.java:5001)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:515)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:785)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:601)
    at dalvik.system.NativeStart.main(Native Method)

 

[Erel]

Can you see the logs in release mode? Do you get the same error message?

 

[gerredtor]

thank you , I have solved the error