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