[SOLVED] Sqlite - database alias doesn't work with TSQLite3Connection?

[Dibo]

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

[kapibara]

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

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

[Dibo]

Thanks! That was it!

[Fripsy]

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!