TOraQuery is updatable without any Update SQLs. Why?
Posted: 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?
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?