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

[Ralph DiMola]

Thanks Peter. Both checked OK. I think this might be a bug unless there is
some data inconsistency that could creep into some data type that the other
platforms ignore. Maybe?? I've seen this using MS Access via ODBC to MYSQL
DBs with invalid data in data types. I'm going to plod along and see what I
can find.

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

-----Original Message-----
From: use-livecode [mailto:use-livecode-bounces at lists.runrev.com] On Behalf
Of Peter Haworth
Sent: Saturday, May 30, 2015 2:26 AM
To: How to use LiveCode
Subject: Re: SQLite and Android "Database Error:Unable to open the database
file"

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
>
_______________________________________________
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