auto complete? text inserts at the end!?!?

Hi Support,
Here is my problem. I type

select * from Account

Then, I wanted to add "top 10" right before *

As soon as I type TOP and hit space bar, the word "TOP" is inserted at THE END of the line, make the sql looks like this
SELECT * FROM Account aTOP

I just upgraded to SQL Assistant 4.6.12 and this starts happening. I don't have any custom settings. Everything is by default. I used it in Microsoft SQL Server Management Studio 9.00.3042.00.

Help please!

Thanks.

Hi,

I'm unable to reproduce this issue. Have you tried restarting your computer after upgrade?

Regards

I have restarted my computer already. I also just uninstalled and reinstalled SQL Assistant again and it doesn't work still.

Which SQL Server service pack is installed on the client?

My SSMS version reads 9.00.1399

I also experience the same exact problem with the same scenario. It happens with other cases as well, but this seems the simplest to reproduce. Again the steps are:

1. Type: SELECT * FROM Account a
2. Click right before the *
3. Type: top
4. You'll see the drop down with keyword assist showing TOP
5. Hit the space bar
6. End up with: "SELECT * FROM Account aTOP "
TOP is moved to the end of the line with the trailing space.

I noticed one factor that makes a difference to the behavior. If I change SQL Assistant Options under Code Formatting then "Convert Keywords to" FROM "Upper-case" to "None" then the problem does NOT happen when hitting the space after typing "top".

However, note that the same problem still happens if after I type "top" and before I hit the space bar, I select "top" from the keyword assist drop-down and hit enter. Then I get the following: "select * from Account atop". Only difference from before is the keywords are lower case and no space at the end of the line.

So, same problem but different trigger in both cases.

I hope you can find a way to solve this problem for us because it makes using SQL Assistant very annoying.

Thank you!

Thank you. The provided information is very helpfull. We will look into this.

My Microsoft SQL Server Management Studio is 9.00.3042.00. Thanks.

My Microsoft SQL Server Management Studio is 9.00.3042.00.

Thanks.

I'm able to reproduce the problem.

In case it's helpful for anyone.

The problem occurs if you enable Word Wrap from Options->Text Editor->All Language. If you disable it, the problem will go away.

Thank you. This is very helpful. I hope we can reproduce this issue now.