It's odd that this is the default setting for the TADOQuery, then. So every
time I plunk a TADOQuery onto a Datamodule, I have to remember to change it
to ltReadOnly? That's dumb.
I rarely to never use a Query to edit() data. I use them to select, insert,
update, or delete. I really detest that it modifies the SQL. That makes it
a million times harder to debug.
When you write the SQL:
Select count(CITIES) from STATES where STATE='CA'
This is a single-group function. It works in PL/SQL developer. Then,
because you didn't explicitly stop it from doing so, when you put it in a
Delphi App hoping to learn how many cities there are in California, you get:
ORA-00937: not a single-group group function
Maybe I'm too much of a purist, but my view is that this hasn't made my life