Re: Loosing Global Variables
When programming in several other languages I have only ever had to dim global variables once.
But I don’t have a problem Dim them again if it solves the problem.
First of all none of my global variable are ever used as local variables so the program should never have a problem with the variables I use.
Second I only seem to have this issue one out of 200 cases of running a script. So I would think that if I have a problem with these global variables then it would happen every time.
Third I have now found that I have a random loss of a few local variables also (all variables are dim using the local form). I have about 25 temporary variables that are only used locally to store temporary information that is displayed on the form. I have a couple of times these variable produce an error of variable not found. (again 1 out of 200 cases)
I said all this to say I think this issue is a symptom of a bigger issue:
My environment is I have the program / database on a server. All computer that access the program are using run time alpha running pointing to the server and running off the server (no shadowed data bases)
There has been a couple of times while the program is running that I get a message that the database can’t be found. \\TPSRV\SAMFolder\solutions\.dbf can’t be found. This error makes no sense considering the program is running and it obviously is still using the database . I have to exit the program and go back in and everything works fine. (same goes for the global and local missing variables) - I am beginning to think these issues are related in some way)
Has anyone else see this issue? Can I trap for this error and resolve it in code?
When programming in several other languages I have only ever had to dim global variables once.
But I don’t have a problem Dim them again if it solves the problem.
First of all none of my global variable are ever used as local variables so the program should never have a problem with the variables I use.
Second I only seem to have this issue one out of 200 cases of running a script. So I would think that if I have a problem with these global variables then it would happen every time.
Third I have now found that I have a random loss of a few local variables also (all variables are dim using the local form). I have about 25 temporary variables that are only used locally to store temporary information that is displayed on the form. I have a couple of times these variable produce an error of variable not found. (again 1 out of 200 cases)
I said all this to say I think this issue is a symptom of a bigger issue:
My environment is I have the program / database on a server. All computer that access the program are using run time alpha running pointing to the server and running off the server (no shadowed data bases)
There has been a couple of times while the program is running that I get a message that the database can’t be found. \\TPSRV\SAMFolder\solutions\.dbf can’t be found. This error makes no sense considering the program is running and it obviously is still using the database . I have to exit the program and go back in and everything works fine. (same goes for the global and local missing variables) - I am beginning to think these issues are related in some way)
Has anyone else see this issue? Can I trap for this error and resolve it in code?
Comment