Good afternoon,
I was looking in the forum about how to handle it but I found different solutions to other problems but not to this.
The problem to be solved is how to deal with "Lost Connection to MYSQL" errors due to disconnection from the internet. I already use "Set TIMEOUT" and also the timer so that the connection is not cut off, but the problem lies with clients with WiFi networks, where, thanks to FiveWin for existing, when they have a micro-cut of a few seconds, it freezes for a couple of seconds and reconnect.
The problem is that when it tries to reconnect and does not do so in 15 seconds, it gives me a [b] Fatal Error [/ b] where the application has to be closed without any other way.
Is there a way to change that time or if the connection was lost, show a msgstop () and return to the previous screen so as not to lose all the load made up to that moment?
Process example:
When you press a button, a query is executed that brings up information. When you press it, it waits for the reconnection, if it does not reconnect within 15 seconds, it throws the "Lost Connection to MySQL" error and forces the user to exit.
It would be a very good tool to implement in all systems, since in Argentina the networks are not made by professionals and the hardware is of poor quality.
Thanks in advance!