Toad World Blog

Intellisense in worksheets | Toad Edge knows how to assist

May 12, 2017 5:36:19 PM by Robert Pound

When creating the video Using worksheets in Toad Edge , I touched briefly on the intellisene feature and how it gives you feedback when writing your queries. I wanted to double back on this topic to give a more detailed example of how this feature can make your life easier.
To complete the query below I had to type: SELECT, FROM, 4 spaces, 2 commas and press enter several times. These items are highlighted with the orange boxes. *Note I had to exaggerate spacing in order to make the numbers readable.
query.png-550x480
I started with SELECT then ignored the feedback that I was already getting, entered a newline and typed FROM on the second line. From there I selected staff which was already table aliased as s.
7776.1.PNG-550x480
Next I entered a space and chose INNER JOINfrom intellisense
7776.2.PNG-550x480
I then entered a space again and chose address which was also table aliased as a.
1581.3.PNG-550x480
I entered another space and choose ON.
1581.4.PNG-550x480
Next came another space and the selection of a.address_id = s.address_id
4214.5.PNG-550x480
Next I moved my cursor back to the SELECT section of the query and choose a.address.
4214.6.PNG-550x480
From here I had to enter a comma and then select s.first_name.
3666.7.PNG-550x480
Finally I had to enter one last comma and then select s.last_name
3666.8.PNG-550x480
So if you do not like taking direction from a development tool or you are a big fan of typing then you may want to disable the Content Assistant under Worksheet preferences. But if you are like me you probably appreciate the assistance!
9.PNG-550x480

Tags: Toad Edge MySQL Development

Robert Pound

Written by Robert Pound

Product Technologist - Managing content for Information Management at Quest