I've read this page several times but just can't get SQLite to work for some reason:
http://wiki.freepascal.org/SQLiteI have a valid sqlite database containing one table, 'company'.
The file 'test.db' is in my application directory and the database name in the SQLConnection is set to the full path... /home/paul/lazarus/test.db. The transaction is set to SQLTransaction 1 which itself has the database set to SQLConnection1.
SQLQuery1 has a simple sql statement 'SELECT * FROM company', transaction property is set to SQLTransaction1.
The Datasource property is marked in red but is empty (is this right??).
I copied file libsqlite3.so.0.8.6 into my application directory and set SQLiteLibraryName:='libsqlite3.so.0.8.6'; in the form's OnCreate event (also tried adding the full path just in case).
Trying to set the query to active gives me a 'no such table' error.
I'm using Mint 17.1 with the latest Lazarus.
Any help appreciated as there's a growing face-shaped dent in my desk
Paul