[Solved] Cant set SQLQuery.Active to true in designtime
lazarus / 16-Databases

----------------------------------------------------------------------
fpcoder · 2013-09-16 02:57

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)

----------------------------------------------------------------------
taazz · 2013-09-16 03:36

is the database name simple foo.db or it has the complete path as
well. It does require the complete path in design mode.

----------------------------------------------------------------------
fpcoder · 2013-09-17 14:15

Yes, it needed the complete path in designtime. Thanks!

Quote from: taazz on September 16, 2013, 05:36:19 amis the database
name simple foo.db or it has the complete path as well. It does
require the complete path in design mode.