Actually I forgot to double check with the cygwin version I have. Makes me wonder if I made something goofy in my port, but it should reside in memory so I am puzzled about what could be wrong. The same piece of software works when I write to flash....
Puzzled.... Mario Hebert Legerity "Jay Sprenkle" <[EMAIL PROTECTED]> 05/17/2006 12:56 PM Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] DB in memory - table create won't work On 5/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > I got flash database to work for me. What I am trying now is to create a > database in memory that I could sync later on in flash. The problem is > that when I do a table create it does not seem to work: > > 1. I open database : memory: with success. > 2. I create a random table: create table test ( a int ); > 3. I try to do an insert: insert into test values (5); > > I get the following error, > > no such table: test works ok for me: C:\Temp\>sqlite3 :memory: SQLite version 3.0.8 Enter ".help" for instructions sqlite> .schema sqlite> create table test(int a ); sqlite> insert into test values(5); sqlite> .schema CREATE TABLE test(int a ); sqlite> select * from test; 5 sqlite>
