I should have stated I am trying to set this as a var in a form. Can this be done in a single line statement?
Steve -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Sunday, November 30, 2008 9:27 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER Steve, You'll have to do this: IF VENDOR2 = NULL THEN SET VAR VENDOR2 = .V_VENDOR2 ELSE SET VAR V_VENDOR2 = NULL ENDIF Claudine ________________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Sunday, November 30, 2008 8:05 AM To: RBASE-L Mailing List Subject: [RBASE-L] - IF NULL STATEMENT OR QUALIFIER I am trying to set vendor2 = v_vendor2 if vendor2 is null and if vendor2 is not null then I want to clear var v_vendor2. I started with this so far. not sure where to go from here? vendorn = (ifnull(.v_vendor Steve
