invalid argument when using a global variable

[Kori]

I know I know it is not good programming rules to use global variables but I do. Few that is. My delima is I am getting a error when I try to read that global variable from another procedure after I have set it. It says it is a "invalid procedure call or argument" Any ideas?

I have a huge sql statement before I read the global variable. Funny thing is if the sql statement pulls things from the data base the global is read fine. If the sql statement does not pull anything from the database the program gets this error, "invalid procedure call of argument"

I would love any suggestions

 

[ITweedlie]

It would help to see that particular procedure.