1 2 3 Previous Next 33 Replies Latest reply on May 14, 2016 2:46 AM by beverly

    ESQL returning a "?" when it should be 0


      I have some ESQL calcs along these lines:


      Calc_n::Route="EN";ExecuteSQL("SELECT SUM (in_water) FROM FeedsUsed WHERE Route='e' AND \"_IOuuID\"=?";"";"";IO 2::__uuID)


      I think that if all the FeedsUsed::in_water = 0, then the above sum field returns "?". I don't understand why and there how to prevent it.

        1 2 3 Previous Next