B4J Question bug in sqlite-jdbc-3.7.2 ?


Licensed User
Longtime User
Hello folks.

I use different pragmas in sqlite.
pragma table_info("mytable").
This works as expected.
select * from pragma_table_info("mytable") returns an error indicating a missing database or syntax error.
However, in my fpc environment both work without any problems.
After trying for 2 hours I thought maybe it was the jdbc library.
I'm using the sqlite-jdbc-3.7.2 in b4j.
now I tested it with version sqlite-jdbc-
And it works as expected.

Have you perhaps observed something similar?
Is there a bug in sqlite-jdbc-3.7.2?
Should I use a certain one and avoid others?

Information would be very welcome.