Mike...
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...
Dixie
> Date: Wed, 24 Aug 2011 15:02:37 -0400
> Subject: Re: sqlite & mySQl hassles...
> From: ad...@mfelkerco.com
> To: use-livecode@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.
>
> Mike
>
> John Dixon <dixo...@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@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
_______________________________________________
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
