Tools: Delphi 2006, IB Objects 4.9.14 Query: SELECT (COUNT(*)+0.00)/2 as "LabelsCount" FROM LABELS
previously worked. Now I get an error: Invalid expression in the select list (not contained in either aggregate function or GROUP BY clause However when I run the query from the SQL editor in Firebird Maestro it works and gives the correct result. Any ideas on why this won't work from Delphi\IB Objects?
