Right now it seems to be working. It seems like it takes me tracing the macro once when the error occurs for it to work. I don't change any of the code.
I have some variables in forms set up where they just equal themselves do those need to be defined before opening the form? I am not using any while loops in the macro but would just having SET WHILEOPT OFF in the macro make in a difference in this case? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Posted At: Wednesday, July 14, 2004 8:59 AM Posted To: RB7-L Conversation: [RBG7-L] - Re: Error Subject: [RBG7-L] - Re: Error At 08:49 AM 7/14/2004 -0500, Charlie Parks wrote: >When a user tries to execute an item from the menu it produces >an error: "Error -unrecognized column in expression". I try >it from the application on my computer it causes the error. I >trace the macro no errors are found. I go back into the >application and the error seems to go away. > >What should I be looking for causes of the error? Charlie, Check to make sure that all global variables are pre-defined with correct data types (if used). What happens when you simply run your macro at the R> prompt? FYI, when you TRACE your macro, WHILEOPT is set to OFF. Very Best R:egards, Razzak.
