I am using Toad for Oracle Base 220.127.116.11; I have asked my company if our licensing includes upgrading to the current version of Toad but I have not received an answer yet.
In Editor -> Code Assist, I have Enable Code Insight pick lists checked, and I have select the objects that I want to see in ‘Toad Insight Objects’. I discovered that when I have the Users object unchecked, code assist does not work where I want it to, but it is still attempting to “assist” in places where I don’t want it to.
For example, if I have the following:
“select u. from apps.fnd_user u”
where typing “u.” should invoke the code assist with a list of fields for that table, nothing happens.
However, when I type the word ‘and’ (in the where clause) and hit space, it automatically changes ‘and’ to ‘andavis’ (I think one of our users/schemas). There seems to be no in between.
Why do I have to have Users checked in order for code assist to work? I don’t want a list of users, I only use one schema, which is set as my default schema.