Fred a wrote: > Hi, > > Thank you for your answer... > You try to reproduce on win32 or linux ? > I think, may be, i have a bug on my porting layer (lock file / unlock > file)... > > But without this problem context, can i : > - open a (new) database > - insert some records > - (don t close db) > - select field > ...?
OK, here is a test... C:\TEMP>sqlite3 test.db SQLite version 3.3.5 Enter ".help" for instructions sqlite> create table test (id integer, description char(20)); sqlite> insert into test values (1, "one"); sqlite> insert into test values (2, "two"); sqlite> insert into test values (3, "three"); sqlite> select * from test; 1|one 2|two 3|three sqlite>.q C:\TEMP> Works fine. Works on Linux too. Try it on your machine - does it work? -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/