well other then the var gets set right it's just when I go to 'run' it using.. &tdvPrintReportCode
it gives the error BUT only in the cursor. outside the cursor it works fine, any thoughts? ----- Original Message ----- From: Lawrence Lustig To: RBASE-L Mailing List Sent: Wednesday, May 07, 2008 1:45 PM Subject: [RBASE-L] - Re: Issues with an absolute var that calls a stored proc with in a while loop... << not sure I follow but I'd do a SET VAR vJunk = &tdvPrintReportCode and then add a line &vJunk and see if that works? >> No, my idea is to try: SET VAR tdvPrintReportCode = "(CALL DoReportCode())" -- note extra parens. SET VAR vx = &tdvPrintReportCode Because the CALL is being done on the right side of a SET VAR statement, R:Base should "pass" the command as a SET VAR, not a CALL command. You may have to do: SET VAR tdvPrintReportCode = " = (CALL DoReportCode())" -- note extra parens. SET VAR vx &tdvPrintReportCode to avoid having the & immediately after the equal sign. -- Larry
