I thing this is probably because the version of the sqlite library included
in the firefox sqlite manager is probably more recent than the one in
Livecode. The sqlite_sequence table seems to hold an entry for every
autoincrement key value and it is maintained by sqlite so it feels like the
sqlite
To you lot...Bob SneiderMike FelkerMark SchonewillieAdminGerry OrkinThanks for
the help you have offered with trying to fathom the problems I am having with
mySQL and sqlite... I have not yet sorted out the mySQL connection problem on a
real device, but have got to the bottom of my sqlite troub
Is the mySQL database set up to allow access from the device? I believe you
need to set the remote client IP address for mySQL installs, for security
reasons - if it's a typical virtual host install, it'll probably be set to
allow access from your desktop machine (the machine you most likely use
Is the mySQL database set up to allow access from the device? I believe you
need to set the remote client IP address for mySQL installs, for security
reasons - if it's a typical virtual host install, it'll probably be set to
allow access from your desktop machine (the machine you most likely use
ments")
> put revOpenDatabase("sqlite","localKnow.db") into gDataBaseRef
> get revDataFromQuery (tab, return , gDataBaseRef, "SELECT * FROM
> towns" )
> put it into theData
>
> revCloseDataBase gDatabaseRef
> take care,Di
t;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
* 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,
>
re...
> 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
> y
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
Right, (at the risk of stating the obvious) since it works in the simulator, it
must be something else than a spelling error. Dixie I'll get back to you.
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://
nk 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
>
Hi Dixie,
Are you using MySQL or SQLite? Those are not the same.
Post your script.
I think you got a dot too many there :-)
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK:
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 wrote:
>
>Hi...Has anyone got mySQL or sqlite databases working on iOS
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 i
14 matches
Mail list logo
