There are more basic issues with code compete than casing.
Code complete does not work for items outside of the database you have selected.
I write all code by hand and the code is wrote so that it does not matter what
database I have selected to be able to run it. I normally open the editor which
is defaulted to Master and I leave it there and start typing code.
Example below. I have opened Toad, it is defaulted to Master and I want to start
typing some code. I am going to write code for the alliance_website database.
I type “select *”, and press enter (for line break), type
“from” and a space and I wait for the code complete to pop up. I
start typing “allia” and nothing shows up. There is no list of
database objects which should be part of this list. They are not there.
Here is how it should display
Also, I have notice something weird with the Toad GUI. If I have the bubble help
(in the first screen it would be the “all_columns” in yellow) and
leave it showing and go to a different application, the bubble help will stay on
top no matter what application I open. So I left the bubble help as you see it
in the first screen and I went to Outlook and you can still see it on top of
Another thing I noticed regarding dual monitors. If I open toad on the left
monitor and then move toad to the right monitor, any dialog boxes will open on
the left monitor. If you open toad and keep it on the monitor it opened on, the
dialog boxes will open on that monitor. They should open on the monitor that
Toad is located on.
Toad does correctly stay on the monitor on which you closed toad. So if I open
toad on the right monitor, move it to the left, close toad, it opens on the left
when I open it again.