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

[Peter Haworth]

Try PRAGMA integrity_check and PRAGMA foreign_key_check.

Pete
lcSQL Software
On May 29, 2015 11:20 PM, "Ralph DiMola" <rdimola at evergreeninfo.net> wrote:

> 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
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>