Recent

Author Topic: Exception with Database GetFieldNames with SQLite databases  (Read 701 times)

Neville

  • New member
  • *
  • Posts: 5
Exception with Database GetFieldNames with SQLite databases
« on: February 22, 2019, 04:08:20 pm »
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

  • New member
  • *
  • Posts: 5
Re: Exception with Database GetFieldNames with SQLite databases
« Reply #1 on: February 22, 2019, 08:14:21 pm »
I find that using TSQLite3Connection works fine, but that doesn't really solve my problem of producing multi=platform software.

rvk

  • Hero Member
  • *****
  • Posts: 3696
Re: Exception with Database GetFieldNames with SQLite databases
« Reply #2 on: February 22, 2019, 08:54:14 pm »
Maybe related: https://bugs.freepascal.org/view.php?id=29819
but that was for MySql and is fixed.

Zvoni

  • Full Member
  • ***
  • Posts: 197
Re: Exception with Database GetFieldNames with SQLite databases
« Reply #3 on: February 23, 2019, 07:05:43 am »
IF it's whichever SQLite-DB you use, maybe it's not the DB but your code.....
One System to rule them all, One IDE to find them,
One Code to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
People call me crazy, because i'm jumping out of perfectly fine aircrafts