[EMAIL PROTECTED] writes: > The situation is: > i have two DBs - one in memory and one in the filesystem. I > need to fill some tables in the second DB from the fist DB. > So, how can I ATTACH DATABASE from memory? > (unfortunately ATTACH DATABASE ":memory:" AS mem; fails ...)
You need to ATTACH the disk-resident database to the memory one, rather than vice versa as you're trying. Since you already have the database handle for the memory-resident database, issue an "ATTACH 'diskdatabase.db' AS disk_db;" command on the memory-resident database handle. Derrell