SQL sometimes fails, how can I allow the user to retry?
Posted: Fri Sep 11, 2009 6:39 am
Hi,
In my installer I have a SQL script; most of the time there is no problem, but on my test system it sometimes fails with a CONNECT_ERROR; I guess the problem is not with the installer...
I was thinking to allow the user to retry the action when this happens, but how can I do this? I've considered label/goto label, but the code running the script is in an if/else statement, and I can't nest labels there..
hopefully there is a common solution for this that hasn't got my attention yet
In my installer I have a SQL script; most of the time there is no problem, but on my test system it sometimes fails with a CONNECT_ERROR; I guess the problem is not with the installer...
I was thinking to allow the user to retry the action when this happens, but how can I do this? I've considered label/goto label, but the code running the script is in an if/else statement, and I can't nest labels there..
hopefully there is a common solution for this that hasn't got my attention yet