Tuesday, October 8, 2013 Tip of the Day: Using Additional Logical Functions in R:BASE eXtreme 9.5 Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.3.21008 or higher www.rupdates.com Keywords: Functions Section.: Logical Functions
R:BASE's Logical Functions can be used to introduce decision making into your application. Traditional Logical Functions include: IFEQ IFEXISTS IFGT IFLT IFNULL (IFEQ(arg1,arg2,arg3,arg4)) If arg1 and arg2 are equal, IFEQ returns the value of arg3. If arg1 and arg2 are not equal, IFEQ returns the value of arg4. (IFEXISTS(arg1,arg2,arg3)) If arg1 contains a value, IFEXISTS returns the value of arg2. If arg1 is null, then the value of arg3 is returned. (IFGT(arg1,arg2,arg3,arg4)) If arg1 is greater than arg2, IFGT returns the value of arg3. If arg1 is less than arg2, IFGT returns the value of arg4 (IFLT(arg1,arg2,arg3,arg4)) If arg1 is less than arg2, IFLT returns the value of arg3. If arg1 is greater than arg2, IFLT returns the value of arg4. (IFNULL(arg1,arg2,arg3)) If arg1 is null, then the value of arg2 is returned. If arg1 is not null, then the value of arg3 is returned. Did you know that the latest version and update of R:BASE eXtreme 9.5 include the following additional Logical Functions? IFGE IFLE IFNE (IFGE(arg1,arg2,arg3,arg4)) If arg1 is greater than or equal to arg2, IFGE returns the value of arg3. If arg1 is less than arg2, IFGE returns the value of arg4. (IFLE(arg1,arg2,arg3,arg4)) If arg1 is less than or equal to arg2, IFLE returns the value of arg3. If arg1 is greater than arg2, IFLE returns the value of arg4. (IFNE(arg1,arg2,arg3,arg4)) If arg1 and arg2 are not equal, IFNE returns the value of arg3. If arg1 and arg2 are equal, IFNE returns the value of arg4. Stay productive, my friends! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase www.RazzakMemon.com -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
