Thank you, Dr. Luettgens.
The answer was so basic and simple, naturally I would forget it within
the "deep weeds" of the actual code.
Solution? Stop coding after 18:00.
Bruce
------ Original Message ------
Sent: 5/3/2016 11:58:17 PM
Subject: AW: [RBASE-L] - Select Statement Divide by Zero Errors
From: "DR. FRITZ LUETTGENS" <[email protected]>
To: [email protected]
Cc:
Create View before with or use directly
WHERE EventCosts OR EventCount > 0
Fritz
Von:[email protected] [mailto:[email protected]] Im
Auftrag von Bruce Chitiea
Gesendet: Dienstag, 3. Mai 2016 22:03
An:[email protected]
Betreff: [RBASE-L] - Select Statement Divide by Zero Errors
All:
When EventCount is NULL or Zero, browsing produces Error #2553 - Divide
by Zero.
Is there a cheap and cheerful way to deal with this WITHIN the select
statement, short of introducing a host of (IFNULL variable constructs?
--Grossly Simplified Example
SET ZERO ON
CREATE TEMP VIEW DivideByZeroTest_tvw +
( ECount , +
ECost , +
EAvgCost ) AS +
SELECT EventCount , +
EventCost , +
EventCost/EventCount +
FROM BlahBlahBlah
--Browse of Death
BROWSE * FROM DivideByZeroTest_tvw
Thanks much
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
