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

2015-06-01 Thread Ralph DiMola
alph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -Original Message- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Bob Sneidar Sent: Monday, June 01, 2015 11:00 AM To: How to use LiveCode Subject: Re: SQLite and Android "Da

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

2015-06-01 Thread Bob Sneidar
OMG Autocorrect is killing me!!! FIREFOX! I MEANT FIREFOX!!! Bob S On Jun 1, 2015, at 08:00 , Bob Sneidar mailto:bobsnei...@iotecdigital.com>> wrote: Try opening the database with an sql utility. Fairfax has a great sqLite plugin that I use all the time. I think it can even check the database

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

2015-06-01 Thread Bob Sneidar
I don’t think it has anything to do with the data in the database, unless the database has been corrupted. If the database is already open by another device, sqLite will not allow you to open it. sqLite is a single user database. Try opening the database with an sql utility. Fairfax has a great

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

2015-05-30 Thread Ralph DiMola
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" wrote: > I am getting the dreaded and extremely unhelpful "Database > Erro

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

2015-05-29 Thread Peter Haworth
Try PRAGMA integrity_check and PRAGMA foreign_key_check. Pete lcSQL Software On May 29, 2015 11:20 PM, "Ralph DiMola" 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 P

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

2015-05-29 Thread 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 ad