Toad World® Forums

Auto complete feature in Toad for SQL Server


#1

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?

Thanks in advance…


#2

Hi,

Thank you very much!

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.

Editor association.jpeg

Options in code Completion.jpeg

Best Regards,

Kelly


#3

Hello Kelly,

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…

Thanks again!!!

2015-01-08 19:23 GMT-08:00 Kelly.Chen bounce-KellyChen@toadworld.com:

RE: Auto complete feature in Toad for SQL Server

Reply by Kelly.Chen
Hi,

Thank you very much!

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.

Best Regards,

Kelly

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for SQL Server - General notifications altogether.

Toad for SQL Server - Discussion Forum

Flag this post as spam/abuse.


#4

Hi,

So sorry for my confuse last time I reply.

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!

Best Regards,

Kelly


#5

Hi,

After discuss, we will not improve this for now, it will cost too much effort to address.

If you have any other questions, please feel free to contact us.

Thank you very much!

Best Regards,

Kelly


#6

Hi Kelly, thanks a lot for the reply, that’s totally understandable although it is a shame for me, great software though…

Thanks!!!

2015-01-12 20:38 GMT-08:00 Kelly.Chen bounce-KellyChen@toadworld.com:

RE: Auto complete feature in Toad for SQL Server

Reply by Kelly.Chen
Hi,

After discuss, we will not improve this for now, it will cost too much effort to address.

If you have any other questions, please feel free to contact us.

Thank you very much!

Best Regards,

Kelly

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for SQL Server - General notifications altogether.

Toad for SQL Server - Discussion Forum

Flag this post as spam/abuse.


#7

Hi,

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.

Hope these can help you.

Best Regards,

Kelly