Thanks. I will try this Thursday - the next day I work.
Patti
From: A. Razzak Memon <raz...@rbase.com>
To: rbase-l@googlegroups.com
Sent: Tuesday, September 26, 2017 4:39 PM
Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
Patti and Karen,
You are both taking the long route home.
Did you know that you can just double click the
displayed code to have the R:BASE Editor launch,
where the desired code can be altered?
The actual EEP syntax or EEP text header (On
Before EEP, On After EEP, etc.) must be double
clicked in order to launch the R:BASE Editor.
Very Best R:egards,
Razzak
At 02:48 PM 9/26/2017, 'Patti Jakusz' via RBASE-L wrote:
>Thanks. It was in the Detail Band so I had a
>hard time finding it. But I found the EEP map
>menu selection and then I could edit it.
>
>Patti
>
>
>
>From: karentellef via RBASE-L <rbase-l@googlegroups.com>
>To: rbase-l@googlegroups.com
>Sent: Tuesday, September 26, 2017 2:45 PM
>Subject: Re: [RBASE-L] - Re: Trying to figure out IFF command
>
>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 <<mailto:walker.bu...@comcast.net>walker.bu...@comcast.net>
>To: rbase-<mailto:l...@googlegroups.com>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 <<mailto:rbase-l@googlegroups.com>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 <<mailto:walker.bu...@comcast.net>walker.bu...@comcast.net>
>To: <mailto:rbase-l@googlegroups.com>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 <<mailto:rbase-l@googlegroups.com>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 <<mailto:bauer...@gmail.com>bauer...@gmail.com>
>To: RBASE-L <<mailto:rbase-l@googlegroups.com>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.
