It is an interesting thing the set zero on or off logic, many overlook it when a certain statement doesn't seem to be calculated correctly (or so they think). Anyway I am still around, just really busy with the prawn farm being sold to an overseas company. Being in the top end of Australia it's warming up as usual. Would have been nice to get over for the anniversary of RBase and meet face to face with others. Anyway hope all is well with you and the other RBase crowd, all the best.
On Thu, Nov 9, 2023 at 6:15 AM Bruce Chitiea <rby...@safesectors.com> wrote: > 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 > > rby...@safesectors.com > (909) 238-9012 m > > > ------ Original Message ------ > From "Tony Luck" <anthonydl...@gmail.com> > To rbase-l@googlegroups.com > 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 <rby...@safesectors.com> > 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 >> >> rby...@safesectors.com >> (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 rbase-l+unsubscr...@googlegroups.com. >> 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 rbase-l+unsubscr...@googlegroups.com. > 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 rbase-l+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/emf6569370-a934-4365-8869-38d5e280c94e%40ffc94789.com > <https://groups.google.com/d/msgid/rbase-l/emf6569370-a934-4365-8869-38d5e280c94e%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 rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDASf2zD-vqbkSyGtT1uXiwgwxvFoepy4i-VR5xXChsARMA%40mail.gmail.com.
