Svein,
Thank you very much. I set KeyLinksAutoDefine to false and the query worked as
written. Also found the workarounds fascinating and educational.
Thanks again.
Ron
--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
wrote:
>
> >Tools: Delphi 2006, IB Objects 4.9.14
> >
> >Qu
>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 e