I'm trying to fetch a sum from a Progress database with "SELECT CEILING(ROUND(SUM(Price),0)) AS price...". This works fine if there is data to be fetched. If it finds nothing it throws me an "Overflow error (7485)".
After a little testing I found that CEILING causes the problem. So this would work "SELECT ROUND(SUM(Price),0)..." for both empty and populated record sets. The problem is that Openedge returns two zero decimals with "Round(),0" which I thought I could get rid of with CEILING.