Thanks for the responses guys. I'll get my hammer out :o) Cheers
Phil Ben Marchbanks-2 wrote: > > 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 > > -- View this message in context: http://www.nabble.com/Adobe-AIR-Version-Issue%28-%29-tp16512203p20640008.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users