Re: MySQL standalone issues

2012-03-21 Thread Pete
I think I vaguely remember running into that once, worth a try. Pete On Tue, Mar 20, 2012 at 8:13 PM, Ken Ray wrote: > > On Mar 20, 2012, at 6:32 PM, Sieg Lindstrom wrote: > > > Next I copied the button containing the working script to my existing > app and saved that as a standalone. This time

Re: MySQL standalone issues

2012-03-20 Thread Ken Ray
On Mar 20, 2012, at 6:32 PM, Sieg Lindstrom wrote: > Next I copied the button containing the working script to my existing app and > saved that as a standalone. This time it didn't open the database. Instead it > returned the answer error "Unable to connect to the database. revdberr, > invalid

Re: MySQL standalone issues

2012-03-20 Thread Sieg Lindstrom
Pete, I investigated further. I found something strange. I copied the simple script below from lessons.runrev.com and put it in a button on a brand new stack. Saved as a standalone and it worked as designed. Next I copied the button containing the working script to my existing app and saved th

Re: MySQL standalone issues

2012-03-20 Thread Pete
Hi Sieg, Doesn't seem like storing data in external files should be a problem, especially since the app has been working for so long, although maybe there's a different path to the files needed for the standalone than in the IDE. Still think there could be clues in a sample of the failing code alo

Re: MySQL standalone issues

2012-03-20 Thread Sieg Lindstrom
Thanks, Pete. That gives me a clue. The LC app of primary concern to me has such a long history it started out as a HyperCard stack (and formerly interfaced with a local database, not MySQL). There are instances in which it temporarily saves data to text files to get around HyperCard's 30,000-ch

Re: MySQL standalone issues

2012-03-20 Thread Pete
Hi Sieg, I don't know of such an article but people on this list can probably help if you give use a bit more detail about what the queries are and what error messages you are getting. There shouldn't be any SQL reasons for things not working in a standalone if they worked in the IDE so I suspect

MySQL standalone issues

2012-03-20 Thread Sieg Lindstrom
Can anyone point me to an article or tutorial that walks thru all the considerations for making MySQL database functionality work in a standalone? I have created several apps that query a MySQL database. They work fine in the IDE but I have never been able to get them to run as standalones, from