Try PRAGMA integrity_check and PRAGMA foreign_key_check. Pete lcSQL Software On May 29, 2015 11:20 PM, "Ralph DiMola" <rdim...@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 > rdim...@evergreeninfo.net > > > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode