TOraQuery is updatable without any Update SQLs. Why?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
inslab
Posts: 1
Joined: Thu 29 Oct 2009 09:46

TOraQuery is updatable without any Update SQLs. Why?

Post by inslab » Thu 29 Oct 2009 10:05

(Delphi 7)
I have a TOraQuery with a SQL text like
"select * from TTable where AnyID = :pAnyID"
update SQL statements are not set.

When I was using Version 5 of ODAC such query was always non-updatable instead of ReadOnly property. In other words, there was no automatic generation of update SQL statements. But after I installed Version 6 I was surprised to find that now all my queries like this becomes updatable!

What is it? A bug/feature in Version 5 or a feature/bug in Version 6 or smth else?

PS: If it's a feature so how can I turn it off?

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

Post by Plash » Fri 30 Oct 2009 08:01

It is a feature of ODAC 6. You may return the old behaviour by setting the OraQueryCompatibilityMode global variable from the Ora unit to True.

Post Reply