Hi!Just upgraded from a much older version (8.6) and find that pick lists no longerwork.What’s changed? I’ve selected every option in View | ToadOptions… | Toad Insight Object and in … | Toad Insight (except thelast – Ctrl + Click jumps to PLSQL object).I found the following thread, too:http://www.toadfororacle.com/thread.jspa?threadID=26168 .But my pick lists fail with both synonyms and non-synonymed tables.Just so I’m completely clear: I expect a list of columns to pop up aftertyping, say,select * from mytable t where t.and waiting 250 msHelp?Thanks!Fred
You can try closing Toad and renaming your User Files\Aliases.txt file andrestarting Toad to see if there is some funk in there. This is what I see. Aslong as you have the View|Options|Editor|Code Assist|"Enable Code Insight picklist" option checked then you should see the same.Michael
I had the same problem. Try prefacing the table name with the schema. Thatworked for me, even though the synonym is valid.Select * from myschema.mytable t where t.Best regards,MikeMichael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The WorldDepends on Sensors and Controls
In View|Options|Editor|Code Assist there is a tree where you can check theobject types to be shown. Public Synonyms are unchecked by default. Have youverified that Public Synonyms (or Synonyms if it is private) is checked? Itshould be able to handle the synonym although I think that there is a bug whereyou have a synonym to a synonym to a table or something like that.Michael
Thanks, Michael. You are correct. The “Synonyms” check box was offin the dialog. Turning it on eliminated the need to preface the table with theschema name. Hope this also helps Fred.Best regards,MikeMichael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The WorldDepends on Sensors and Controls
I tried Michael Staszewksi’s trick and removed my ALIASES.TXT file. Thatworked. Once. Now, nothing.Both ‘Synonyms’ and ‘Public Synonyms’ are checked.What else affects pick-list performance? Should I just roll back to 8.6?Fred
We'll need some very specific steps to reproduce. I can't reproduce this so afull description of exactly what you are doing and what the objects are willhelp. If you can't post the exact query that is showing the problem then try toget a reproducible case using SCOTT objects or one of the other demo schemas orSYS objects.1. Please provide a sample query which does not work. Include information oneach of the objects in the query. Are they synonyms? Public or private? Are theysynonyms to synonyms? If not synonyms, are the tables owned by the schema youare logged in as?2. Does the query exist in an editor tab by itself? If not, what else is in thetab? If there is other code before/after the query does it make a difference ifyou add a blank line before/after the statement?3. How far are you drilling into the object? By this I mean are you just typing. and waiting or have you started typing letters after theperiod and are then waiting such as .ABC? If so, is ABC aprefix to more than 1 column in the table? If not, the picklist won't show IIRCand just the one possible match should be inserted into the editor.You can also use SQL Monitor (or SQL Tracker depending on your version of Toad)to monitor all SQL sent to the DB by Toad to resolve your object. It is locatedin your Toad installation directory. Start Toad, connect to database, openEditor, start SQL Monitor, enable tracing of Toad, reproduce scenario. Sendresults to us.Michael
Does it work if you preface the table name with the alias?Best regards,MikeMichael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The WorldDepends on Sensors and Controls
Sorry, meant to say does it work if you preface the table name with the schemain which it belongs?Best regards,MikeMichael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The WorldDepends on Sensors and Controls
Thanks! I’ll do that. Not right away, I’m afraid, but Real Soon Now.
That's fine, take your time. Also, a first step may be to try this. In the CodeAssist options there is an option to cache the results. Uncheck that and try.Caching will greatly improve performance of subsequent fetches, but if yourobjects change often then this will result in incomplete results. It's possiblethat the cache is corrupt or outdated and it doesn't find anything useful foryou. Unchecking that option forces a full refresh on every display.Michael
No, it doesn’t; I did try your suggestion as well. If you continueinterested, I’ll be posting a more complete description of the problem inthe next day or two.
Please post what you have when you have time.Thanks,Michael