If you haven't already downloaded it checkout Christian Coenreats SQLite Admin written in AIR.
http://coenraets.org/blog/2008/02/sqlite-admin-for-air-10/ Its a big help for me as my SQLite dbs are created on a Linux server (a select backup from mySQL) and then I embed them into my AIR project on mac OSX. SQLite Admin helps verify schema and test queries etc... *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 Ben Marchbanks wrote: > Yes I did resolve it using a large hammer - > > I just delete the previous sqlite backup file using ulink since for my > purposes its a total > backup anyway. > > It would be good to know how to do incremental changes as an option - > let me know if you find a solution. > > One thing I did notice is that the file permission were set to > -rwx-rwx-r-x instead of drwx-rwx--r-x as > I would expect using chmod 0775. > > I think that PHP-PDO is a clumsy implementation. > > *Ben Marchbanks* > > www.magazooms.com <http://www.magazooms.com/> > Signature > Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > Phone: (864) 284.9918 > > > phillipm wrote: > >> tiggyboo wrote: >> >> >>> I created and populated a table via sqlite3 on a Mac OSX machine, and have >>> no problem working with it from the sqlite3 prompt. However, when I try >>> to access the sole table (named cftable) in this database via a very >>> simple Adobe AIR application I'm working on, I get this error: >>> >>> Error #3115: SQL Error.', details:'no such table: cftable' >>> >>> My question - would this be typical of a version conflict for sqlite, >>> i.e., is the latest release of AIR perhaps using an embedded sqlite that >>> is not compatible with what I have (3.1.3) on my machine? I have yet to >>> determine which version is embedded in AIR. >>> >>> Thanks, >>> Al >>> >>> >>> >> Just wondering if you resolved this issue - I'm experiencing the same >> situation. Very simple project, small database in the project folder????? >> >> Any help appreciated, thanks >> >> >> Phil >> >> > _______________________________________________ > 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
