ORA-01466 on a view

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Quake_MSC
Posts: 6
Joined: Wed 18 Jul 2007 09:59

ORA-01466 on a view

Post by Quake_MSC » Wed 27 Aug 2008 09:42

Dear people,

since version 06.30 of odac, i get the error message on connecting with TOraTable on a view.

Message:
ORA-01466: Cannot select ROWID from, or sample, a view with DINSTINCT, GROUP BY, etc.

well... i tried to deactivate prefetching or the property fetchrows, but no success.

Have anyone an idea ?

Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Thu 28 Aug 2008 08:43

Set the KeyFields property to prevent this error.

Post Reply