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 Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
------ Original Message ------
Sent: 9/25/2017 12:33:34 PM
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
From: "'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.
