AnsweredAssumed Answered

Rounding in ExecuteSQL

Question asked by dlewis@taylor.n-lanark.sch.uk on May 14, 2018
Latest reply on May 14, 2018 by user19752

Script below not working - giving error 8309

 

 

ExecuteSQL ( "

 

SELECT Category, round(AVG(Price),2) as RoundedPrice FROM Plant

GROUP BY Category

 

";"";"" )

 

However, works fine when I remove the rounding element.

 

SELECT Category, AVG(Price) as RoundedPrice FROM Plant

GROUP BY Category

 

Where am I going wrong???

 

 

Cheers

 

 

David

Outcomes