Gidday Stephen The database seems to write fine. I have it loading into a datagrid in my Flash AIR desktop app, from where I read it and make edits to it.
On Thu, Nov 7, 2013 at 2:54 AM, Stephen Chrzanowski <pontia...@gmail.com>wrote: > The 15 seconds "smells" like a time out. I've found in the past where if > the database being accessed is in read only mode (Either by filesystem > permissions, or just the plain old READ ONLY file attribute) SQLite > pauses. I can dupe this with using any utility, be it the SQLite CLI or > PHP or SQLite Expert, etc. Changing the DB into something that is > read-only locks it down. Try doing something to the database that needs a > write and see if you get an error. > > > On Mon, Nov 4, 2013 at 6:12 AM, SongbookDB <shaun_thom...@songbookdb.com > >wrote: > > > Thanks Clemens > > > > Flash gives the error - no such function: 'sqlite_version' > > > > SQLite Administrator says 3.5.1 > > > > I'll see what the Adobe community say. > > > > > > > > > > On Mon, Nov 4, 2013 at 9:30 PM, Clemens Ladisch <clem...@ladisch.de> > > wrote: > > > > > SongbookDB wrote: > > > > The database has an index that is being used according to EXPLAIN > QUERY > > > > PLAN in SQLite Administrator. Does Flash use the same SQL code? > > > > > > Probably not. Try "SELECT sqlite_version();". > > > > > > > > > Regards, > > > Clemens > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@sqlite.org > > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > > > -- > > Shaun Thomson > > Owner - SongbookDB > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Shaun Thomson Owner - SongbookDB _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
