| Subject | Problem with query after upgrade FB 2.1x to 2.5.1 |
|---|---|
| Author | Ron |
| Post date | 2012-04-09T07:45:38Z |
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?
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?