Unable to retrieve fields definition from dataset with SQLite
database...
lazarus / 10-Designer

----------------------------------------------------------------------
gelinp · 2015-10-26 10:43

Hello,

I've got an error message when I attempt to specify fields attributes
of my querie.: "Unable to retrieve fields definition from dataset".

It's like lazarus IDE doesn't know about my databse connection with
SQLite file...I try to start lazarus with debug mode :

startlazarus --debug-log=/home/gelinp/.lazarus/lazarusdebuglog.txt

But I can't see any more  error messages into the log file...

A test with PostgreSQL is a little different. Object inspector can't
retrieve fields definitions from database too, but there is no error
message it display. Only en empty list to choose Field Name...

As exemple of project image_mushrooms I understand may be I need to
add two components :
sqlitelaz
sqlite3laz
Could you tell me if I must install this components to my project in
order Lazarus retrieve fields definitions with SQLite database. And
may be also lazreport to take variable list from TSQLQuery (it's empty
for my projet) ?

So I tried to compile with FPC 2.6.4 but I've got an error. I tried
with FPC 3.1.1 and I succeded. But now I failed to install into
lazarus (static include) because of one more error :

/usr/bin/ld: cannot find -lsqlite 

I can find the library here :

/usr/local/lib/fpc/3.1.1/units/i386-linux/sqlite/sqlite.o

But it look strange to add this library path because I succeded to
install some other component without to do it for there libraries ...
And I don't know where to add this path : component library, option to
create lazarus (I tested -Fl option without success) ???

Thank you for your help !

----------------------------------------------------------------------
gelinp · 2015-11-02 11:51

I respond to myself. It was a problem with a debian package for SQLite
dev not installed.