Got exactly the SAME issue
With PHP 4.3 and the sqlite 3 extension. But was reversed. When creating :memory: database, its worked, But when creating :file database I got the "No such table" problem. I ve let down sqlite . And I ve retake mysql. Good luck Best Regards Derel Bruno -------Message original------- De : Jay Sprenkle Date : 05/17/06 20:03:17 A : sqlite-users@sqlite.org Sujet : 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>
