Gerry Snyder wrote:

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


No, but thanks Jay for your reply.

-Randy

Reply via email to