If I understand correctly, the use of PRAGMA is deprecated and my routine for obtaining the properties of fields uses it.
However, I have now created a new SQLite DB to test with a recent version of a tool and developed a test b4j project, which worked (it lists, for each table, table name and "all" the properties of each field).
In version 2.06 (posted in post#1), there are two methods for B4A (ExecuteSpinner and ExecuteListView) and one for B4J (ExecuteTableView) that are surrounded with #If/#Else If/#End If compiler conditionals. The B4J compiler conditional is
#Else If B4J
This produces an error when used in a NON_UI application (the TableView object is not available in a NON_UI application) and therefore should be changed to
#Else If UI
I've not check out the unofficial version above to see if it has the same issue.