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>