Hey Tony, thanks. Good philosophy.
I had thought of SET ZERO OFF as a LOCAL toggle, not as a database
default (RTFM, my bad. ) I'm gonna go conservative at the local level
with this approach:
IF varname IS NOT NULL OR varname > 0 THEN
--do the [ > 0 ] thing
ELSE
--do the [ NULL | < 0 | = 0 ] thing
ENDIF
How's your springtime? Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "Tony Luck" <[email protected]>
To [email protected]
Date 11/8/2023 11:26:46 AM
Subject Re: [RBASE-L] - SET ZERO
Morning Bruce,
Interesting question over the morning cuppa. In general I consider that
the "IF varname > 0" is a comparison statement and setting zero on or
off doesn't affect the outcome, in saying that however should there be
a calculation i.e. set var vresult = (.v1 + .v2 + .v3) prior to the
comparison logic I personally set zero on if there is any chance of one
of the variables being a null value as it may return a null causing the
'IF" statement to fail if zero was off. Anyway just my thoughts on how
I use SET ZERO.
On Thu, Nov 9, 2023 at 4:23 AM Bruce Chitiea <[email protected]>
wrote:
All: Does SET ZERO affect the parsing of this code: IF varName > 0
THEN ... where varName is INTEGER? In other words, is that expression
considered to be a mathematical expression by the parser?
From R:SYNTAX: "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
<https://www.rbase.com/support/rsyntax/rbgX5/datatypes.html>. "
Thanks very much, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emec448425-3b7c-4b7c-ba3a-0f4d80b83e12%40ffc94789.com
<https://groups.google.com/d/msgid/rbase-l/emec448425-3b7c-4b7c-ba3a-0f4d80b83e12%40ffc94789.com?utm_medium=email&utm_source=footer>.
--
Regards
Tony
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CABnhDAR1_ttSfUdXnoMdrfHxPPC-wMCg1XHmK8v_bQPxKw63Lw%40mail.gmail.com
<https://groups.google.com/d/msgid/rbase-l/CABnhDAR1_ttSfUdXnoMdrfHxPPC-wMCg1XHmK8v_bQPxKw63Lw%40mail.gmail.com?utm_medium=email&utm_source=footer>.
--
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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/emf6569370-a934-4365-8869-38d5e280c94e%40ffc94789.com.
