DELPHI使用ADO连接ORACLE经常提示ora-00979的解决方法
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博客 ” ，链接：https://blog.itpub.net/341285/viewspace-980720/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
DELPHI 快捷键
请登录后发表评论
登录
全部评论
