Steve, Check out the help for IFNULL. Try this IFNULL(VENDOR2,.V_VENDOR2,NULL)
Jan -----Original Message----- From: "Steve Breen" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Sun, 30 Nov 2008 09:41:00 -0500 Subject: [RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER I was given this at one time but can not remember how it works. vendorn = (ifnull(.v_vendorn, vendorn, .v_vendorn)) It may sound silly but I need to how something works to impliment it and I am no longer sure about this line. 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
