your solution is most probably in os_unix.c, have a look at the file system APIs...
Mario Hebert Legerity "Night Media LTD" <[EMAIL PROTECTED]> 05/17/2006 01:28 PM Please respond to sqlite-users@sqlite.org To <sqlite-users@sqlite.org> cc Subject [sqlite] Réf. : Re: [sqlite] Réf. : Re: [sqlite] DB in memory - table create won't work Oh ... !! Because its a special filesystem ! I got this problem on a VPS server running with XEN 3.0 And the harddisk is /dev/sda1 (but don't know the filesystem). Best Regards Derel Bruno -------Message original------- De : [EMAIL PROTECTED] Date : 05/17/06 20:19:55 A : sqlite-users@sqlite.org Sujet : Re: [sqlite] Réf. : Re: [sqlite] DB in memory - table create won't work Well, I could understand more your situation since it was probably because The sync with the hardware was not ported properly to your platform and Data was not being saved to the media. Although, I just can't make sense Why the opposite happens to me.... *sigh* Mario Hebert Legerity "Night Media LTD" <[EMAIL PROTECTED]> 05/17/2006 01:06 PM Please respond to sqlite-users@sqlite.org To <sqlite-users@sqlite.org> CC Subject [sqlite] Réf. : Re: [sqlite] DB in memory - table create won't work 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> __________ Information NOD32 1.1543 (20060517) __________ Ce message a ete verifie par NOD32 Antivirus System. http://www.nod32.com
