You cannot change the code from within that "code" tab at the bottom, if that's
what you're trying to do. You have to edit it from where it's located. What
kind of control is it in? Bring up the properties of that control, look for
the "eep" tab at the top, and you'll see highlighted in yellow where the eep
code is. You edit it there.
Karen
-----Original Message-----
From: 'Patti Jakusz' via RBASE-L <rbase-l@googlegroups.com>
To: rbase-l <rbase-l@googlegroups.com>
Sent: Tue, Sep 26, 2017 12:58 pm
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
I need help.
I figured out how to get the code in there. But I made a typo and so the code
didn't work and now I can't get it back out and I can't edit it.
I see that Settings drop down box on the right side where it lets you select
"Edit on start of EEP" or "Edit on cursor position", but it's not letting me
edit the code.
Patti
From: Buddy Walker <walker.bu...@comcast.net>
To: rbase-l@googlegroups.com
Sent: Tuesday, September 26, 2017 12:21 PM
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
No problem. I won’t have access to my pc for about 3 hours or so. If any
questions just ask.
Buddy
Sent from my iPhone
On Sep 26, 2017, at 11:15 AM, 'Patti Jakusz' via RBASE-L
<rbase-l@googlegroups.com> wrote:
No, I didn't know about it (or was told and forgot.) I just found the Code
tab. I'll try to figure it out.
Thanks!
Patti
From: Buddy Walker <walker.bu...@comcast.net>
To: rbase-l@googlegroups.com
Sent: Tuesday, September 26, 2017 11:01 AM
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
Patti
Have you tried using on before eep in the detail band to test for null and
write your IF statement there.
Buddy
Sent from my iPhone
On Sep 26, 2017, at 10:09 AM, 'Patti Jakusz' via RBASE-L
<rbase-l@googlegroups.com> wrote:
Nope. Still didn't work.
Thank you for your help. I'm giving up and creating a temp table and
converting the field to a 1 or 0 in the temp table.
Patti
From: Michael Byerley <bauer...@gmail.com>
To: RBASE-L <rbase-l@googlegroups.com>
Sent: Monday, September 25, 2017 10:54 PM
Subject: [RBASE-L] - Re: Trying to figure out IFF command
If nulls are to be evaluated in your expressions, you need to set ZERO ON:
Syntax: SET ZERO ON/OFF
Default: OFF
SET ZERO allows a null to be treated as a zero in a mathematical expression
involving INTEGER, NUMERIC, REAL, DOUBLE, CURRENCY, DATE, DATETIME, or TIME
data types. With ZERO set on, R:BASE returns a negative number when you
subtract an integer from a null. With ZERO set off, the same computation
results in a null. R:BASE stores the setting with the database.
Otherwise your expression will fail unless you are evaluating for a NULL
condition as in using IFNULL.
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.
