Re: [sqlite] how to execute an ATTACH DATABASE?

2010-03-07 Thread Sam Carleton
There is another condition I didn't see originally: You have to attach to the other database BEFORE starting the transaction. P.S. Who ever is responsible for putting in helpful error messages, God bless you! On Sun, Mar 7, 2010 at 4:34 PM, Sam Carleton wrote: > On Sun, Mar 7, 2010 at 4:1

Re: [sqlite] how to execute an ATTACH DATABASE?

2010-03-07 Thread Sam Carleton
On Sun, Mar 7, 2010 at 4:16 PM, Jean-Christophe Deschamps wrote: > >>ATTACH DATABASE ?1 as sysDB > > AFAIK you can't use parameter binding for anything else than litteral > values. > > It makes sense since it would be impossible for the parser and > optimizer to evaluate and produce run-time code

Re: [sqlite] how to execute an ATTACH DATABASE?

2010-03-07 Thread Jean-Christophe Deschamps
>ATTACH DATABASE ?1 as sysDB AFAIK you can't use parameter binding for anything else than litteral values. It makes sense since it would be impossible for the parser and optimizer to evaluate and produce run-time code for a statement without knowing beforehand which database or column the sta

[sqlite] how to execute an ATTACH DATABASE?

2010-03-07 Thread Sam Carleton
I just posted a question a few minutes ago and it just dawned on me that the order I am calling things in that post is be ideal, so much that I would like to combine both web services calls. I want the transaction that enableSlideShow() creates to also execute the SQL which is called in setDefault