[All]
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.