B4J Question SQL- ExecQuerySingleResult error

tcgoh

Active Member
Licensed User
Longtime User
Hi,
I am have problem with SQL.ExecQuerySingleResult("SELECT name FROM table WHERE TM = '0000'")
B4X:
java.sql.SQLException: column 2 out of bounds [1,1]
    at org.sqlite.RS.checkCol(RS.java:71)
    at org.sqlite.RS.markCol(RS.java:78)
    at org.sqlite.RS.getString(RS.java:313)
    at anywheresoftware.b4j.objects.SQL$ResultSetWrapper.GetString2(SQL.java:378)
    at anywheresoftware.b4j.objects.SQL.ExecQuerySingleResult2(SQL.java:274)
    at anywheresoftware.b4j.objects.SQL.ExecQuerySingleResult(SQL.java:257)
    at b4j.example.main._btnpage1_action(main.java:206)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:93)
    at anywheresoftware.b4a.BA$2.run(BA.java:159)
    at com.sun.javafx.application.PlatformImpl$4$1.run(PlatformImpl.java:179)
    at com.sun.javafx.application.PlatformImpl$4$1.run(PlatformImpl.java:176)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sun.javafx.application.PlatformImpl$4.run(PlatformImpl.java:176)
    at com.sun.glass.ui.win.WinApplication._runLoop(Native Method)
    at com.sun.glass.ui.win.WinApplication.access$100(WinApplication.java:29)
    at com.sun.glass.ui.win.WinApplication$3$1.run(WinApplication.java:73)
    at java.lang.Thread.run(Thread.java:724)

Can anyone help?
Thanks
TC
 
Top