B4J Question TableView or InsertMaps?

[giga]

Is there a limit to how many rows you can have in tableview or InsertMaps?

InsertMaps (first query out of 999): INSERT INTO [TestTable] ([test_number], [test_name], [description], [test_example]) VALUES (?, ?, ?, ?)

If I stay at 999 it comes up.

if I go to 1000 it comes up with this error. (** No Content in Table**)

Program started.
DropTable3: DROP TABLE IF EXISTS [TestTable]
CreateTable: CREATE TABLE IF NOT EXISTS [TestTable] ([test_number] INTEGER PRIMARY KEY, [test_name] TEXT, [description] TEXT, [test_example] TEXT)
InsertMaps (first query out of 1000): INSERT INTO [b4acodeTable] ([code_number], [code_name], [description], [code_example]) VALUES (?, ?, ?, ?)
Error occurred on line: 92 (dbutils).
java.sql.SQLException: [SQLITE_MISMATCH] Data type mismatch (datatype mismatch)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sqlite.DB.newSQLException(DB.java:387)
at org.sqlite.DB.execute(DB.java:342)
at org.sqlite.PrepStmt.execute(PrepStmt.java:65)
at anywheresoftware.b4j.objects.SQL.ExecNonQuery2(SQL.java:120)
at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at anywheresoftware.b4a.shell.Shell.runVoidMethod(Shell.java:503)
at anywheresoftware.b4a.shell.Shell.raiseEventImpl(Shell.java:215)
at anywheresoftware.b4a.shell.Shell.raiseEvent(Shell.java:153)
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:601)
at anywheresoftware.b4a.BA.raiseEvent2(BA.java:93)
at anywheresoftware.b4a.ShellBA.raiseEvent2(ShellBA.java:69)
at anywheresoftware.b4a.BA.raiseEvent(BA.java:84)
at b4j.example.main.start(main.java:33)
at com.sun.javafx.application.LauncherImpl$5.run(LauncherImpl.java:319)
at com.sun.javafx.application.PlatformImpl$5.run(PlatformImpl.java:206)
at com.sun.javafx.application.PlatformImpl$4.run(PlatformImpl.java:173)
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:722)
(Exception) java.lang.Exception: java.sql.SQLException: [SQLITE_MISMATCH] Data type mismatch (datatype mismatch)
ExecuteMemoryTable: SELECT test_number FROM TestTable
ExecuteMemoryTable: SELECT test_name FROM TestTable
ExecuteMemoryTable: SELECT description FROM TestTable
ExecuteMemoryTable: SELECT test_example FROM TestTable

 

[giga]

Nevermind, I discovered my issue was a NumberFormat error.