Bug? B4XPages always reports the same line number for SQLLite errors

MrKim

Well-Known Member
Licensed User
Longtime User
First let me say I LOVE B4XPages. I wish I had had this years ago when I first started working with B4a. It would have made life so much simpler.

Minor and not sure if this is fixable but it is annoying to me and perhaps indicative of other issues. I am using SQLLite with B4XPages. If there is an SQL error it is ALWAYS on line 15 (B4XPages)
B4X:
Error occurred on line: 15 (B4XPages)
java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (near "*": syntax error)
    at org.sqlite.DB.newSQLException(DB.java:383)
    at org.sqlite.DB.newSQLException(DB.java:387)
    at org.sqlite.DB.throwex(DB.java:374)
    at org.sqlite.NativeDB.prepare(Native Method)
    at org.sqlite.DB.prepare(DB.java:123)
    at org.sqlite.Stmt.execute(Stmt.java:113)
    at anywheresoftware.b4j.objects.SQL.ExecNonQuery(SQL.java:161)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:676)
    at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:240)
    at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:167)
    at jdk.internal.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:91)
    at anywheresoftware.b4a.shell.ShellBA.raiseEvent2(ShellBA.java:98)
    at anywheresoftware.b4a.keywords.Common.CallSub4(Common.java:487)
    at anywheresoftware.b4a.keywords.Common.access$0(Common.java:467)
    at anywheresoftware.b4a.keywords.Common$CallSubDelayedHelper.run(Common.java:541)
I am playing with the 3 pages example, and line 15 of the main page happens to be Private bxtTable As B4XTable in Main that line happens to be MainForm.Show, ont the page that is erroring (one I added to the example) it is a declarations Private PictureImg As B4XView
if that is any help.
On other errors the line shows correctly..
 
Last edited:
Top