Try enclosing the table name in sequel quotes `towns`. try using a full reference to the table using the database name `mydatabase`.`towns`. (Obviously substitute mydatabase with the name of your own).
Bob On Aug 25, 2011, at 3:31 PM, John Dixon 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
