Hello, I’m new to Toad’s world and I love it so far, I have version 6.5.0.3282 installed but there seem to miss a feature in autocomplete, why aren’t SQL keywords appearing at all in suggestions when typing code? is not that I don’t know the commands it just allow you to write queries faster. I’ve tried enabling all the options but none of them seem to work and that’s a definite must for me when writing SQL code faster, is that a bug or is just a missing feature for this tool?
For now ToadforSQLServer Code Completion works only when there are at least one connected connection. Please kindly make sure the Editor you opened is associated with a schema or a instance.
And Toad also has related options, like attachment. Would you like to try some options in code completion see if it can work?
If you have any problem, please feel free to contact us.
thanks so much for the reply, here's the deal, I'm aware of that but even with the things you're telling me SQL reserved keywords are not appearing on the auto complete list so I can type faster queries, here's an example in where I would like to have the "WHERE" keyword autocompleted but instead is not doing it...
Same happpens with SELECT, INNER, OUTER, LEFT, UPDATE, etc... as I said, it just makes the code way faster to write, not for memory issues where I don't know the keywords, is just that I work writing lots of SQL statements a day so I need to write faster queries...
For now ToadforSQLServer Code Completion works only when there are at least one connected connection. Please kindly make sure the Editor you opened is associated with a schema or a instance.
And Toad also has related options, like attachment. Would you like to try some options in code completion see if it can work?
If you have any problem, please feel free to contact us.
The ToadforSQLServer Code Completion not support the the SQL Keyword for now. We sorry for your inconvenience. I create task TSS-822 for this. I will keep you update for this. Thank you very much!
Thank you. And sorry to tell you late. In Toad, we have an feature called Code Snippets. It also can help us for writing script.
We can open the Code Snippets window on main menu View->Code Snippets.
In the Editor, place the cursor where you want to insert the snippet, then do one of the following:
Double-click the snippet in the Code Snippets window.
Press CTRL+SPACE to select from a list of snippets (organized in folders by snippet type).
Drag the snippet from the Code Snippets window to the insertion point.
But for now, it seem have some issue in 6.6 when using Ctrl+Space. The other two way can be used. We are looking at this. I will keep you update about this.
