--- R S <[EMAIL PROTECTED]> wrote:
> Hi, > I have a requirement where I need to update 2 tables in 2 separate > DBs within a transaction. Do I need to attach the second table to the > first at the start of the transaction? As I understand SQLite commits > a transaction across a single DB only? > Thanks! > Right, you need to attach the second database using the ATTACH command. If you are using version 3 and your original database is not an in-memory database, then the transaction involving two databases will be atomic. http://www.sqlite.org/lang_attach.html ____________________________________________________ Start your day with Yahoo! - make it your home page http://www.yahoo.com/r/hs
