[SOLVED] Sqlite - database alias doesn't work with TSQLite3Connection?
lazarus / 16-Databases

----------------------------------------------------------------------
Dibo · 2014-12-02 21:51

Hi,

I'm using "attach database <database file> as coll'". Then I can use
this alias for create tables: CREATE TABLE coll.<table name>. But when
try with SELECT/INSERT/UPDATE:
Code: [Select]    q.SQL.Text := 'SELECT 1 FROM coll.coll_paths LIMIT
1';
    q.Open;
... then I get error "EDatabaseError near "." : syntax error " . Copy
paste into sqlitebrowser or sqliteman is working fine without syntax
error. Even "select * from main.<some table>" raise same exception
since "main" should always exists.

Regards

----------------------------------------------------------------------
fpcoder · 2014-12-03 03:37

I had the same problem a while ago, but it was quickly solved here:

http://forum.lazarus.freepascal.org/index.php/topic,24751.msg149381.ht
ml#msg149381

----------------------------------------------------------------------
Dibo · 2014-12-04 19:13

Thanks! That was it!

----------------------------------------------------------------------
Fripsy · 2016-02-09 13:57

For those having the same problem, and finding that the link above
doen't work anymore...

Just set ParseSQL to false in TSQLQuery, that's all!