AnsweredAssumed Answered

ESQL returning a "?" when it should be 0

Question asked by tays01s on May 8, 2016
Latest reply on May 14, 2016 by beverly

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.

Outcomes