Correct me if I'm wrong but Steve is trying to manipulate too many variables to use an IFNULL function.
Claudine _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Sunday, November 30, 2008 9:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER Steve Basically it comes down to if arg1 is null then set the variable to arg2 else set it to arg3. See the examples below Buddy Example 1 SET VAR arg1 INTEGER = NULL SET VAR arg2 INTEGER = 2 SET VAR arg3 INTEGER = 3 VTempArg = (IFNULL(.arg1,.arg2,.arg3)) VTempArg will be set to 2 Example 2 SET VAR arg1 INTEGER = 0 SET VAR arg2 INTEGER = 2 SET VAR arg3 INTEGER = 3 VTempArg = (IFNULL(.arg1,.arg2,.arg3)) VTempArg will be set to 3 Buddy From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Breen Sent: Sunday, November 30, 2008 9:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER Jan, Help me, what does this do ?? I am not as good as you. Steve _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Sunday, November 30, 2008 9:46 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER 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
