RE: [sqlite] ATTACH and :memory: databases

2007-02-07 Thread Dan Kennedy
Nothing that I've tried works. > -Dave Gierok > > -Original Message- > From: Dan Kennedy [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 07, 2007 9:56 AM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] ATTACH and :memory: databases > > On Wed, 2007-

Re: [sqlite] ATTACH and :memory: databases

2007-02-07 Thread Dennis Cote
Dave Gierok wrote: When I open the 2nd :memory: database and call attach on the first one specifying ':memory:' as the file name, Dave, You can't do that. You need to attach the second memory database to the memory database you already have open. Each time you open or attach to :memory:

RE: [sqlite] ATTACH and :memory: databases

2007-02-07 Thread Dave Gierok
- From: Dan Kennedy [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 07, 2007 9:56 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ATTACH and :memory: databases On Wed, 2007-02-07 at 09:37 -0800, Dave Gierok wrote: > I would like to attach a :memory: database to another :memory: datab

Re: [sqlite] ATTACH and :memory: databases

2007-02-07 Thread Dan Kennedy
On Wed, 2007-02-07 at 09:37 -0800, Dave Gierok wrote: > I would like to attach a :memory: database to another :memory: database. How > is this possible since the ATTACH command requires the database's file name? > > ATTACH [DATABASE] database-filename AS database-name > > -Dave Gierok I don't

[sqlite] ATTACH and :memory: databases

2007-02-07 Thread Dave Gierok
I would like to attach a :memory: database to another :memory: database. How is this possible since the ATTACH command requires the database's file name? ATTACH [DATABASE] database-filename AS database-name -Dave Gierok