Exception with Database GetFieldNames with SQLite databases
lazarus / 16-Databases

----------------------------------------------------------------------
Neville · 2019-02-22 15:08

Using 2.0.0 and component TSQLConnector to access both Firebird and
SQLite.

I find that the procedure GetFieldNames(t,SL) performs as expected
when addressing a Firebird Database, but throws an exception when
addressing a SQLite database with the message Field not found:
column_name.

I'm attaching a screen shot of the error message, and a SQLite
database file, although the error happens whichever SQLite database I
use.

----------------------------------------------------------------------
Neville · 2019-02-22 19:14

I find that using TSQLite3Connection works fine, but that doesn't
really solve my problem of producing multi=platform software.

----------------------------------------------------------------------
rvk · 2019-02-22 19:54

Maybe related: https://bugs.freepascal.org/view.php?id=29819
but that was for MySql and is fixed.

----------------------------------------------------------------------
Zvoni · 2019-02-23 06:05

IF it's whichever SQLite-DB you use, maybe it's not the DB but your
code.....