Thanks Stephen - had a quick play with SQLite Expert just now before sleep - found a 3.7.4 dll and dropped it in and it loaded up fine. I'll see if the queries take the same time as in Flash tomorrow.
On Thu, Nov 7, 2013 at 10:53 PM, Stephen Chrzanowski <pontia...@gmail.com>wrote: > SQLite Expert allows you to use any SQLite DLL. Its free for > non-commercial use, but even that said, its an awesome package to buy, life > time upgrades, and seemingly always being updated. > > http://www.sqliteexpert.com/ > > > > On Wed, Nov 6, 2013 at 7:30 PM, SongbookDB <shaun_thom...@songbookdb.com > >wrote: > > > Just got a reply re the version Flash uses - it's 3.7.4 RC4, which is > later > > than what SQLite Administrator uses (3.5.1). > > > > Is there a program like SQLite Administrator that will let me load a > > particular version of SQLite, so my testing will match the version in > Flash > > AIR? > > > > FYI - he used this to get the version from AIR - SELECT > sqlite_source_id() > > - and then looked the hash code returned up on the SQLite timeline at > > http://www.sqlite.org/cgi/src/info/a586a4deeb253300 > > > > > > On Thu, Nov 7, 2013 at 11:21 AM, Simon Slavin <slav...@bigfraud.org> > > wrote: > > > > > > > > On 7 Nov 2013, at 12:09am, SongbookDB <shaun_thom...@songbookdb.com> > > > wrote: > > > > > > > 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. > > > > > > I don't understand how any SQLite app can return the error you gave: > > > > > > >> Flash gives the error - no such function: 'sqlite_version' > > > > > > All APIs that allow you to execute SQLite commands should let you > execute > > > > > > SELECT sqlite_version() > > > > > > so perhaps you have better ask the Flash Pro people about this problem. > > > > > > Simon. > > > _______________________________________________ > > > 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
