Thanks. I'll try that tomorrow.Patti
From: Buddy Walker <walker.bu...@comcast.net>
To: rbase-l@googlegroups.com
Sent: Monday, September 25, 2017 6:02 PM
Subject: RE: Re[4]: [RBASE-L] - Re: Trying to figure out IFF command
#yiv2923735604 #yiv2923735604 -- _filtered #yiv2923735604
{font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv2923735604
{panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv2923735604
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv2923735604
#yiv2923735604 p.yiv2923735604MsoNormal, #yiv2923735604
li.yiv2923735604MsoNormal, #yiv2923735604 div.yiv2923735604MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;}#yiv2923735604 a:link,
#yiv2923735604 span.yiv2923735604MsoHyperlink
{color:blue;text-decoration:underline;}#yiv2923735604 a:visited, #yiv2923735604
span.yiv2923735604MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv2923735604
p.yiv2923735604msonormal0, #yiv2923735604 li.yiv2923735604msonormal0,
#yiv2923735604 div.yiv2923735604msonormal0
{margin-right:0in;margin-left:0in;font-size:11.0pt;}#yiv2923735604
span.yiv2923735604EmailStyle20 {color:windowtext;}#yiv2923735604
.yiv2923735604MsoChpDefault {font-size:10.0pt;} _filtered #yiv2923735604
{margin:1.0in 1.0in 1.0in 1.0in;}#yiv2923735604 div.yiv2923735604WordSection1
{}#yiv2923735604 Patti I would use the IFNULL function along with the IFF
(IFNULL(.var1,0,(iff(('.var1>2 and .var1<6'),1,0)))) I haven’t really tested
it but if var1 is null then a 0 is returned otherwise the IFF will be tested.
Buddy From: 'Patti Jakusz' via RBASE-L [mailto:rbase-l@googlegroups.com]
Sent: Monday, September 25, 2017 4:15 PM
To: rbase-l@googlegroups.com
Subject: Re: Re[4]: [RBASE-L] - Re: Trying to figure out IFF command That
doesn't explain why my 2nd function only works when .var1 is set to a constant.
var1 = 3var2 = (iff('((.var1>2) and (.var1<6))',1,0)) and notvar1 =
(ifnull(COLName,0,COLName))var2 = (iff('((.var1>2) and (.var1<6))',1,0)) I
haven't changed a thing in my syntax. From: Bruce Chitiea
<rby...@safesectors.com>
To: rbase-l@googlegroups.com
Sent: Monday, September 25, 2017 4:09 PM
Subject: Re[4]: [RBASE-L] - Re: Trying to figure out IFF command Patti: I
think Mike Byerley gave us both the best clue, based on the R:BASE help
language: "It is important to note that the condition needs to be a single
item." (emphasis added) ... and we can see this in Example 01 of the help:
(IFF('.v1<.v2','First','Second')) This suggests that the condition (here:
.v1<.v2) may be as complex as you like, so long as it is quoted as shown.
Bruce ------ Original Message ------Sent: 9/25/2017 12:58:52 PMSubject: Re:
Re[2]: [RBASE-L] - Re: Trying to figure out IFF commandFrom: "'Patti Jakusz'
via RBASE-L" <rbase-l@googlegroups.com>To: "rbase-l@googlegroups.com"
<rbase-l@googlegroups.com>Cc: I tried reassigning my variable to a value that
I didn't care about, if it was null. And it still didn't work.I tried setting
EQNULL on and that didn't change anything. That would have screwed up other
things on my report anyway. Patti From: Bruce Chitiea <rby...@safesectors.com>
To: rbase-l@googlegroups.com
Sent: Monday, September 25, 2017 3:54 PM
Subject: Re[2]: [RBASE-L] - Re: Trying to figure out IFF command Patti: I was
about to post a similar IFF question when yours arrived. Great minds. My
question had to do with my code failing when assigning NULL as my arg1 value.
Similar to your insight: "so maybe the whole function will only work if that
column is not null." RSYNTAX offers this clue: "The data types of arg1 and
arg2 must match." Is this another way of saying that a NULL result cannot be
assigned within an IFF statement? Bruce ChitieaSafeSectors, Inc.909.238.9012
Mobile ------ Original Message ------Sent: 9/25/2017 12:33:34 PMSubject: Re:
[RBASE-L] - Re: Trying to figure out IFF commandFrom: "'Patti Jakusz' via
RBASE-L" <rbase-l@googlegroups.com>To: "rbase-l@googlegroups.com"
<rbase-l@googlegroups.com>Cc: Just to try something, I set var1 to a constant
instead of a column name. Then it worked. So maybe the whole function will
only work if that column is not null. Thank you for the correct syntax, Mike.
I think I can figure something out from here. I wish the examples in Rbase
help had been a little more sophisticated. Patti From: Michael Byerley
<bauer...@gmail.com>
To: RBASE-L <rbase-l@googlegroups.com>
Sent: Monday, September 25, 2017 3:24 PM
Subject: [RBASE-L] - Re: Trying to figure out IFF command Sorry. Explain:
Enclose each comparison in its own parentheses so it evaluates properly. Order
precedence. Then the two expressions evaluate within their own parentheses
within the quotations.
On Monday, September 25, 2017 at 2:58:21 PM UTC-4, Patti Jakusz wrote:
Hello, I'm using Rbase X and creating a new report. I have a field in my
database, that can have a value of 0,1,2,3,4,5,7 or 8. If it has a value of
3,4 or 5, I want a checkbox to be checked. So I'm trying to use this new (new
to me) command IFF. I set a report variable (var1) = to the field in the
database. (I tried using just the field name, and that didn't work
either.)Then another variable var2 = (iff(('.var1>2 and .var1<6'),1,0)) The
definition of IFF says you can use "and", but then Rbase doesn't like
it.(IFF((condition),arg1,arg2))The condition must list a set of conditions that
combine to form a statement that is either true or false. Conditions can be
combined with the connecting operators AND, OR, AND NOT, and OR NOT. but
then it further states:It is important to note that the condition needs to be a
single item, which is why quotes are used in the examples below. ??????? I
get the following errors:Constant cannot be followed by a column/variable If I
add more quotation marks '.var1>2' and '.var1<6'then I get the following error:
Nulls cannot be used in comparisons other than NE or EQ What am I doing
wrong?Thank you,Patti
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout. --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout. --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout. --
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
