My project essentially creates a backup of selected records from mySQL in SQLite.
If I don't completely delete the previous backup (SQLite database file) I cannot create a new backup. In otherwords the database is locked and I cannot drop tables etc.... Simple work-around for me was to delete the db file and start fresh. If you are using AIR besure to "clean project" to move your sqlite database to the bin-debug folder. I had the same issue just today - I realized my updated SQLite table was not being used by the debugger. *Ben Marchbanks* www.magazooms.com <http://www.magazooms.com/> Signature Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: (864) 284.9918 DMcQ wrote: > Hi Ben, > > Would you mind explaining what you mean by " delete the previous sqlite > backup file"? > > I'm running into a 'no table found' error (when I can see it's there using > SQLite Data Browser app), but I don't know of any backup file that's > created. > > Any hints greatly appreciated. > > Daniel > > > Ben Marchbanks-2 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
