[fpc-pascal] TSqlite3Dataset and Attach Database

[Malcolm Poole]

Hi,

Can anyone tell me if it is possible to attach another database file to 
a TSQlite3Dataset before opening a query.

I've tried using 'ATTACH "<filename>" AS dataDB;' as the first line of 
the DS SQL but I always get an error: 'dataDB is already in use'.

No error is returned if I run the SQL using 
sqlite3_exec(DS.SqliteHandle...) but of course I can't access the 
returned table using the 'Fields' functions.

Thanks,

Malcolm