Another Gotch ya... If you connect to a MySql DB (although https to back-end server is preferred) every time you do a query of some sort first do something simple like "SELECT 'I am Here'" or list the tables and see if you get back a number for the record set or a list of tables. If not then close the connection(found this keeps things from going sideways) and then re-connect to the MySql server.
Ralph DiMola IT Director Evergreen Information Services rdim...@evergreeninfo.net -----Original Message----- From: use-livecode [mailto:use-livecode-boun...@lists.runrev.com] On Behalf Of Sannyasin Brahmanathaswami via use-livecode Sent: Saturday, September 02, 2017 12:22 AM To: How to use LiveCode Cc: Sannyasin Brahmanathaswami Subject: Re: TSNet error 6 Ralph I'm just about to implement this in our new app. I was only checking on init and some other navigation points in the app, but it's clear now we have to check *everytime* we call the server. because, as you say, use can walk from his desk (wifi) to outside (drop to bad 3G) and then out into the open (suddenly gets 3 bars LTE) and the to the café (back up with 5 bar wifi) all in a 10 minute walk! how do you "see if…( it is) fast enough" is the assumption that if you get something in under 2000 milliseconds than things should work OK, or are you tracking some packet stream? Also why not just put a text file on the server https://www.mydomain.com/ping.text with the word "true" Apple does this this… but their little static page just has the word "success" returned. does your script give some advantage? Brahmanathswami On 9/1/17, 11:10 AM, "use-livecode on behalf of Ralph DiMola via use-livecode" <use-livecode-boun...@lists.runrev.com on behalf of use-livecode@lists.runrev.com> wrote: The first thing I do before any network access is to ping my server with a https request to a LC backend server script that returns "OK". I set the timeout for 2 seconds. If the returned data is not "OK" or take more than 2 seconds then I put the app into off-line mode. I try to ping the server every time the users does "x" or the user's action again need network access and see if the network is back online or fast enough. _______________________________________________ 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
