On Wed, Jun 04, 2008 at 07:58:02AM +1930, Hildemaro Carrasquel scratched on the
wall:
> Hello.-
>
> but how can i make a different between all db on RAM if you define as
> :memory: ?
If you use the SQL command 'ATTACH DATABASE' you name the database.
For example:
ATTACH DATABASE ':memory:' AS db1;
ATTACH DATABASE ':memory:' AS db2;
ATTACH DATABASE ':memory:' AS db3;
And then you just use the names:
CREATE TABLE db1.t (i INTEGER);
CREATE TABLE db2.t (i INTEGER);
And so on.
If you use the sqlite3_open*() interface, each time you open the
"file" :memory:, a new database structure will be returned.
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"'People who live in bamboo houses should not throw pandas.' Jesus said that."
- "The Ninja", www.AskANinja.com, "Special Delivery 10: Pop!Tech 2006"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
