sqlite & mySQl hassles...

[Pete]

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 <dixonja at 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: 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.
> >
> > Mike
> >
> > 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:
> > >http://lists.runrev.com/mailman/listinfo/use-livecode
> > _______________________________________________
> > use-livecode mailing list
> > use-livecode at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>
>