You can declare a variable as a public variable to make it available to all the procedures throughout the entire module. However, this not only makes the variable available to all procedures, but it can also be updateable by all procedures, whether or not it is meant. So there is a possibility that one procedure could affect another in an undesired way. This problem can be somewhat avoided by copying the public variable to a local variable at the procedure level. Doing this protects the variable at the local level from further updates.


What is Metadata?
What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular