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)
I am playing with the 3 pages example, and line 15 of the main page happens to be
if that is any help.
On other errors the line shows correctly..
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)
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: