DELPHI使用ADO连接ORACLE经常提示ora-00979的解决方法

最新推荐文章于 2024-11-01 13:42:03 发布

couhezhongjia0384

最新推荐文章于 2024-11-01 13:42:03 发布

阅读量268

点赞数

文章标签：数据库

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.

就是将ADOQUERY的CursorLocation改成clUseServer.就可以了。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/341285/viewspace-980720/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/341285/viewspace-980720/