[RBASE-L] - RE: IF NULL STATEMENT OR QUALIFIER

[Walker, Buddy]

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: rbase-l@rbase.com [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: rbase-l@rbase.com [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: rbase-l@rbase.com (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: rbase-l@rbase.com [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: rbase-l@rbase.com [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