Recent

« previous next »
Pages: [1]

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

Neville

  • New Member
  • *
  • Posts: 41
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.
Logged

Neville

  • New Member
  • *
  • Posts: 41
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.
Logged

rvk

  • Hero Member
  • *****
  • Posts: 6169
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.
Logged

Zvoni

  • Hero Member
  • *****
  • Posts: 2330
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.....
Logged
One System to rule them all, One Code to find them,
One IDE to bring them all, and to the Framework bind them,
in the Land of Redmond, where the Windows lie
---------------------------------------------------------------------
Code is like a joke: If you have to explain it, it's bad
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018