On Wed, Feb 23, 2011 at 12:50 PM, BareFeetWare <list....@barefeetware.com> wrote: > On 21/02/2011, at 8:11 AM, Scott Hess wrote: >> You can also convert: >> ATTACH DATABASE x AS y KEY z >> to: >> SELECT sqlite_attach(x, y, z) >> where the parameters can be turned into bind arguments. Then embedded >> quotes won't be an issue. > > SQLite won't allow an "attach" statement within a transaction. If I use the > select > sqlite_attach() function, I presume I can place that within a transaction, > yes? > If I rollback the transaction, will it detach?
Transactions are forbidden by the implementation in attachFunc(), not by the syntax of how you called it. -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
