Hi Jason,

I'm executing following statement in IB_Query:
'select round(sum(field1),2) from table1'

and getting ISC error 335544569, SQL error code -104
'Invalid expression in the select list(not contained in either an aggregate function or the GROUP BY clause)'.

field1 type is double precision.

Firebird server 2.5, IBObjects 4.9.11, Delphi 7

What I'm doing wrong?

Thanks