Re: Re: [sqlite] Have SQLite and it's wrappers a possibility to use inmemory tables ? QID129 (KMM126091V41895L0KM)
Thank you for contacting PayPal. I am not sure what your email to us is referring to. Please be more specific or supply a case number. Please let me know if you need further assistance. Sincerely, Stephanie PayPal Resolutions Department PayPal, an eBay Company Original Message Follows: take a look at "attach" in the docs On 4/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi ! > > I need to create a program in Delphi/Windows. I think that SQLite is > best for it. > But: > I need inmemory tables with "infile tables". > > 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 ? > > Please help me: > ft > > Ps: > Ok, I can use Delphi records, Delphi datasets to store inmemory datas. > But they are not joinable with infile tables... :-( > > -- Cory Nelson http://www.int64.org
Re: [sqlite] Have SQLite and it's wrappers a possibility to use inmemory tables ?
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 : : +---+-+
Re: [sqlite] Have SQLite and it's wrappers a possibility to use inmemory tables ?
take a look at "attach" in the docs On 4/28/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi ! > > I need to create a program in Delphi/Windows. I think that SQLite is > best for it. > But: > I need inmemory tables with "infile tables". > > 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 ? > > Please help me: > ft > > Ps: > Ok, I can use Delphi records, Delphi datasets to store inmemory datas. > But they are not joinable with infile tables... :-( > > -- Cory Nelson http://www.int64.org
[sqlite] Have SQLite and it's wrappers a possibility to use inmemory tables ?
Hi ! I need to create a program in Delphi/Windows. I think that SQLite is best for it. But: I need inmemory tables with "infile tables". 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 ? Please help me: ft Ps: Ok, I can use Delphi records, Delphi datasets to store inmemory datas. But they are not joinable with infile tables... :-(