Oma, Hit send by mistake, was not done. I am not sure vendor2 is a column This works vendorn = (ifnull(.v_vendorn, vendorn, .v_vendorn)) This does not
vendor2 = (ifnull(.v_vendor2, vendor2, .v_vendor2)) It sets in form ok and I can exit the form and run the form right away from a R; prompt and it works ok, but when I run the application it errors out. Then can go back into form and enter it and save and it is fine again. I am working with a existing application so this can be dificult to figure out at times. I am trying to repeat a pllication process here for searching for vendor 1 for searching for a second vendor. searching for vendor one returns vendorn and searching for vendor 2 returns vendor2. In some cases we enter the vendor number and in other cases the variable v_vendorn or v_vendor2 is returned and set in the column vnedorn or vendor2. Any way this is a very basic explanation of what I am trying to accomplish. Steve ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Oma Sent: Saturday, November 15, 2008 7:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Unrecognized Global Variable Error Should it be vendor2 = (ifnull(.v_vendor2,.vendor2, .v_vendor2)) Period before vendor2? Best Regards, Oma Cox O.C. Services Inc. P.O. Box 5485 Brandon, MS 39047 662.820.7599 601.992.6785 www.ocservicesinc.com ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Friday, November 14, 2008 8:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Unrecognized Global Variable Error Can anyone see why I am getting this error? -ERROR- Unrecognized global variable in expression. (2161)- >From the following line? vendor2 = (ifnull(.v_vendor2, vendor2, .v_vendor2)) Steve
