So, some while ago, I decided to be clever and keep most of my VBScript code as user code. This is shared between IQbases which meant that I didn't need to keep copying VBScript code whenever I started a new IQbase.
Unfortunately, at some recent point, I have lost a significant amount of my user code. Furthermore, as far as I can tell, when I seek to go back to a much older IQbase which I believe should contain that old code, I still do not see the missing code.
Three questions:
1. Where is user code stored; is it in the most recently opened IQbase? In some deep recess of the InfoQube product itself? In the registry???
2. How can I go back to some earlier version of that user code?
3. For the future, how can I safely back up the user code? Or what other strategy do you recommend?
This is a very serious problem for me. Unfortunately, I have not kept my source code elsewhere than in the product and – like all good programmers – the documentation for my code is in the code itself. Not all my code is gone; but a significant amount of more recent code has, and to rewrite it will take me considerable time. Arghhh!
Unfortunately, at some recent point, I have lost a significant amount of my user code. Furthermore, as far as I can tell, when I seek to go back to a much older IQbase which I believe should contain that old code, I still do not see the missing code.
Three questions:
1. Where is user code stored; is it in the most recently opened IQbase? In some deep recess of the InfoQube product itself? In the registry???
2. How can I go back to some earlier version of that user code?
3. For the future, how can I safely back up the user code? Or what other strategy do you recommend?
This is a very serious problem for me. Unfortunately, I have not kept my source code elsewhere than in the product and – like all good programmers – the documentation for my code is in the code itself. Not all my code is gone; but a significant amount of more recent code has, and to rewrite it will take me considerable time. Arghhh!
Comments
Yes, it does help. It helps to prove that it is always very wise to backup before making significant changes…! Now that I know which folder contains the user code, I will make sure to keep it safe in the future.
I still do not know what I did to cause the loss of certain user code; I suspect it was a problem of my own creation whereby I had the same IQbase open twice, made changes to the user code and then closed the IQbase instances in the "wrong" order. Whatever the cause, the lesson is clear: make sure to keep things safe!
I note also that this probably puts into question the wisdom of keeping everything in user code. By splitting code between different IQbases, with some code in each different database, the danger of corruption or loss of the whole code base is minimised.