Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Bring up toad intellisense

When typing a query in Toad it usually brings up an intellisense scrolling box to help with my typing.

But sometimes this does not appear. Is there a short cut (like in Visual Studio) to bring it up?

EDIT I found that the key mapping is CTRL+.

For a query like

SELECT * FROM Person AS P
WHERE P. -- I expect intellisense to show me the columns. 
         -- Sometimes it does not and pressing the CTRL+. does nothing

Pressing CTRL+. away from a query brings up a very long list of things like -

@@CONNECTIONS @@CPU_BUSY @@CURSOR_ROWS @@DATEFIRST @@DBTS @@ERROR

Do I have the correct shortcut key?

Is the problem that Toad can't figure out the column names in the query above?

EDIT 2

Very strange behavior

If I have

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

BUT if I have the following in the editor -

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

USE DB2 
SELECT * FROM Company AS C
WHERE C. -- No intellisense

Solution below in my own answer

like image 485
tom Avatar asked Feb 08 '13 18:02

tom


Video Answer


3 Answers

I suggest you to use CTRL+T combination. I used it and it works. Also Dell official support agrees, here too. Toad is not the greatest software for best user experience :)

like image 77
evilone Avatar answered Nov 04 '22 06:11

evilone


CTRL-TAB will bring it up for you.

hope this helps!

like image 26
Rachel Gallen Avatar answered Nov 04 '22 06:11

Rachel Gallen


It seems if there is a second USE on the page intellisense will not work with queries below the second USE!

If I have

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

BUT if I have the following in the editor -

USE DB1
SELECT * FROM Person AS P
WHERE P.--I get the intellisense

USE DB2 
SELECT * FROM Company AS C
WHERE C. -- No intellisense

It seems if there is a second USE on the page intellisense will not work with queries below the second USE!

like image 42
tom Avatar answered Nov 04 '22 07:11

tom