Hi John, Could you publish one of the queries that is causing the problem? That might give a clue. Pete Molly's Revenge <http://www.mollysrevenge.com>
On Thu, Aug 25, 2011 at 3:31 PM, John Dixon <dixo...@hotmail.co.uk> wrote: > > 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 > > _______________________________________________ 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
