Pete...
The MySQL script that works... but just not on a real device...
/* get the data from the database */
get
revOpenDatabase("mysql","www.xxxxxx.com","xxxxxxxx","xxxxxxx","xxxxxxx")
put it into gDatabaseRef
get revDataFromQuery( tab, return, gDatabaseRef, "SELECT Name,GPSPosition
FROM towns;")
revCloseDataBase gDatabaseRef
put empty into gDatabaseRef
set itemDel to tab
sort lines of it by item 1 of each
put it into theData
The sqlLite script... works in the IDE but not in the simulator...
/* get the data from the database */
set the defaultfolder to specialFolderPath("documents")
put revOpenDatabase("sqlite","localKnow.db",,,,) into gDataBaseRef
get revDataFromQuery (tab, return , gDataBaseRef, "SELECT * FROM towns" )
put it into theData
revCloseDataBase gDatabaseRef
take care,Dixie
> Date: Thu, 25 Aug 2011 16:38:05 -0700
> Subject: Re: sqlite & mySQl hassles...
> From: p...@mollysrevenge.com
> To: use-livecode@lists.runrev.com
>
> 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
_______________________________________________
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
