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.
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.
