[RBASE-L] - Select Statement Divide by Zero Errors

[Bruce Chitiea]

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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.