Randy Graham wrote:
It sure would be nice to be able to attach one mem db to another. -Randy
Didn't Jay Sprenkle's code do what you wanted? Jay Sprenkle wrote:
sqlite> create table x(y text); sqlite> insert into x(y) values('one'); sqlite> select * from x; one sqlite> attach ":memory:" as db1; sqlite> create table db1.x(y text); sqlite> insert into db1.x(y) values('two'); sqlite> select * from db1.x; two sqlite> select * from x; one sqlite> attach ":memory:" as db2; sqlite> create table db2.x(y text); sqlite> insert into db2.x(y) values('three'); sqlite> select * from db2.x; three sqlite> select * from db1.x; two sqlite> select * from x; one sqlite>
Gerry