kpmais Member Licensed User Longtime User May 3, 2024 #1 Hello folks. I use different pragmas in sqlite. Example: 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-3.39.2.0. 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.
Hello folks. I use different pragmas in sqlite. Example: 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-3.39.2.0. 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.
aeric Expert Licensed User Longtime User Jul 30, 2025 #2 The table-valued functions for PRAGMA feature was added in SQLite version 3.16.0 (2017-01-02). source: https://www.sqlite.org/pragma.html Upvote 0
The table-valued functions for PRAGMA feature was added in SQLite version 3.16.0 (2017-01-02). source: https://www.sqlite.org/pragma.html
