I wanted to try SQLite and made a test database 'foo.db'.
It has a single table named 'foo'. Test app attached:
SQLiteConnection.databasename:=foo.db
SQLiteConnection.connected:=true
SQLTransaction.active:= true
In the SQL property of the Query I have put:
SELECT * FROM foo
But when I try to set Query.Active to true I get:
'no such table: foo'
At runtime everything works, but not in design mode and I have no clue why.
(I have Lazarus 1.1 SVN 42442 and fpc 2.7.1)