sqlite & mySQl hassles...
dixonja at hotmail.co.uk
Thu Aug 25 18:31:37 EDT 2011
Thank you for the reply... the scripts for getting the data from the mySQL database work in the IDE and in the iphone simulator, they will not work on a real device. The app just crashes... the sqlite scripts also run in the IDE and return the requested data, though they do not wish to run in the iphone simulator returning the error "revdberr,Database Error: no such table: towns"... However, if I query the database, using "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;" it tells me that the table towns exixsts... so, I think that misspelling is not the culprit here...
> Date: Wed, 24 Aug 2011 15:02:37 -0400
> Subject: Re: sqlite & mySQl hassles...
> From: admin at mfelkerco.com
> To: use-livecode at lists.runrev.com
> Look for a misspellings or accidental caps or something - SQL is telling you no such table exists. I have encountered this before and making sure your naming conventions are 100% will most certainly help.
> John Dixon <dixonja at hotmail.co.uk> wrote:
> >Hi...Has anyone got mySQL or sqlite databases working on iOS ?I have a mySQL database that runs well in the iphone simulator, but crashes on a real device... No problem, I thought... I'll make a sqlite database and run it from within the app...The sqlite database runs fine on the desktop, but in the simulator throws an error... "revdberr,Database Error: no such table: towns"... I am a little stumped and confused...If anyone has databases playing nicely, I would appreciate some pointers to how you have gone about getting it to work ... as I would really like to find out why the mySQL db runs in the simulator but falls over on an iphone... and err, why it tells me the table is not present in the sqlite db..thanksDixie
> >use-livecode mailing list
> >use-livecode at lists.runrev.com
> >Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode