At 09:16 AM 7/14/2004 -0500, Charles Parks wrote:
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?
In that case, make sure that all variables used on the right side of the expression start with the dot ".".
Without the dot on the right side of expression, R:BASE will assume that value as column name and will generate the following error:
-ERROR- Unrecognized column in expression".
Hope that helps!
Very Best R:egards,
Razzak.
-----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.
