[fpc-pascal] TSqlite3Dataset and Attach Database

Malcolm Poole malcolm at lingua-z.co.uk
Sun Feb 12 13:06:17 CET 2012


On 12/02/12 11:36, Malcolm Poole wrote:
> Can anyone tell me if it is possible to attach another database file 
> to a TSQlite3Dataset before opening a query.
>

OK, I worked this one out myself: I called 
TSQlite3Dataset.ExecSQL('ATTACH "<filename>" AS dataDB;') before calling 
TSQlite3Dataset.Open and it worked.

It's amazing how the mere action of sending a question to a mailing list 
can stimulate the brain :)

Sorry about the noise,

Malcolm



More information about the fpc-pascal mailing list