On Tue, Mar 11, 2014 at 6:35 AM, <ftrib...@falcon-one.com> wrote: > Hi, > > I found a problem in sqlite. > > In essence, here is what my code does: > 1 - It opens a database file > 2 - If it doesn't find certain tables, it assumes this is a new one and > creates the necessary tables and add a few entries in one of them (let's > call it mytable) > 3 - It queries mytable by doing a 'SELECT xyz, abc FROM mytable;' > > When I run this code on Debian, I don't have any problem. > > When I run it on my evaluation kit (ARM9), step 3 fails saying 'no such > table: mytable'. I found out that closing and then re-opening the database > file works. So I do steps 1 and 2, and close and re-open the database > file, and now step 3 works fine! > > For the time being, I have this workaround of closing/re-opening the > database file, but that's really a kludge. > > Any idea about from where this could come from? >
No ideas. Please enable the error and warning log ( http://www.sqlite.org/errlog.html) and see if that provides any further information. > > Many thanks for any ideas! > > Fabrice > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users