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
#yiv3415330516 #yiv3415330516 --blockquote.yiv3415330516cite
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cccccc;}#yiv3415330516 blockquote.yiv3415330516cite2
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cccccc;margin-top:3px;padding-top:0px;}#yiv3415330516 a img
{border:0px;}#yiv3415330516 ol, #yiv3415330516 ul
{list-style-position:inside;}#yiv3415330516 body
{font-family:Tahoma;font-size:12pt;}#yiv3415330516 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.
