TADOQuery, Oracle "ORA-00979: not GROUP BY expression"

Abstract: TADOQuery, Oracle "ORA-00979: not GROUP BY expression"

Product: BDS

Version: 2006

Personality: Delphi Win32

Problem Description:

My application connects to Oracle via ADO. When using an ADOQuery object with a Group By in the query, I get the error "ORA-00979: not GROUP BY expression

Problem Resolution:

This may be caused by the CursorLocation property. By default this is set to clUseClient. The problem can be made to go away by specifying clUseServer.