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 "" AS dataDB;') before calling
TSQlite3Dataset.Open and it wor
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 "" 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
s