Recent

Author Topic: [Solved] Cant set SQLQuery.Active to true in designtime  (Read 2916 times)

kapibara

  • Hero Member
  • *****
  • Posts: 532
[Solved] Cant set SQLQuery.Active to true in designtime
« on: September 16, 2013, 04:57:44 am »
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)


« Last Edit: September 23, 2013, 11:55:09 pm by kapibara »
Lazarus trunk / fpc 3.0.4 / Debian 10 - 64 bit

taazz

  • Hero Member
  • *****
  • Posts: 5365
Re: Cant set SQLQuery.Active to true in designtime
« Reply #1 on: September 16, 2013, 05:36:19 am »
is the database name simple foo.db or it has the complete path as well. It does require the complete path in design mode.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

kapibara

  • Hero Member
  • *****
  • Posts: 532
Re: Cant set SQLQuery.Active to true in designtime
« Reply #2 on: September 17, 2013, 04:15:48 pm »
Yes, it needed the complete path in designtime. Thanks!

is the database name simple foo.db or it has the complete path as well. It does require the complete path in design mode.
Lazarus trunk / fpc 3.0.4 / Debian 10 - 64 bit

 

TinyPortal © 2005-2018