Re: [fpc-pascal] TSqlite3Dataset and Attach Database

2012-02-12 Thread Malcolm Poole
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

[fpc-pascal] TSqlite3Dataset and Attach Database

2012-02-12 Thread 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 "" 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

Re: [fpc-pascal] TSqlite3Dataset

2008-01-06 Thread Luiz Americo Pereira Camara
JK Smith at Grid-Sky wrote: Luiz, Good work. How thread safe is your code? I don't have deep knowledge in thread programming so i can't answer that. The only thing i know about thread safe is that is bad to use global variables. TSqlite3Dataset does not uses. If someones knows some flaw

[fpc-pascal] TSqlite3Dataset

2008-01-06 Thread JK Smith at Grid-Sky
Luiz, Good work. How thread safe is your code? Tried any blob fields? Thanks, James ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal