On Fri, 29 Apr 2005 08:30:00 +0200, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > This app. is get many datas from another DB. But because these datas are > not fitted in memory, I need SQLite to put them into local file/local DB. > But I want to use some datas in memory - with same functions like SQLite > base functions (so I don't want to write them to file, I want to use > them as in memory). > > So: is SQLite supports the inmemory tables, and inmemory SQL commands ?
Open a memory database and attach to your file database. D:\sqlite>sqlite3 :memory: SQLite version 3.2.1 Enter ".help" for instructions sqlite> create table bill (aaa integer); sqlite> insert into bill values (2); sqlite> attach "atest.db3" as b; sqlite> select * from b.bob; 1 sqlite> select * from bill union select * from b.bob; 1 2 sqlite> insert into b.bob select * from bill; sqlite> select * from b.bob; 1 2 sqlite> .exit D:\sqlite>sqlite3 atest.db3 SQLite version 3.2.1 Enter ".help" for instructions sqlite> .schema CREATE TABLE bob (afield integer not null); sqlite> .exit +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : [EMAIL PROTECTED] : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+
