SQLite and Android "Database Error:Unable to open the database file"

[Ralph DiMola]

I am getting the dreaded and extremely unhelpful "Database Error:Unable to open the database file". This only happens on Android. Works in the IDE on either Mac or PC. Works on iOS. Fails only with some queries. Other queries work just fine. This started after I added some data. If I just add additional criteria to a select query encompassing new data that failed then query will work? Or if the first item in the WHERE clause does not reference any of the new data it works. You can select ALL the data and it works. I'm guessing that there is some data inconsistency that only the Android library cares about. Any ideas how to run this down? Are there any utilities to verify the integrity of an SQLite DB? I load the db from an LC utility that shells to export a .xls to a .txt tab delimited file and then reads in the text file and adds records to the DB.

Ralph DiMola
IT Director
Evergreen Information Services
rdimola at evergreeninfo.net