Entering a column alias with a keyword converts keyword to upper case

[hobiedave]

When I type a query such as:

SELECT 1 AS [My Group]

Upon enter the ']' the keyword Group is automatically converted to uppercase. Because this is an alias and not a keyword, it should not be converted.

I do have keywords configured to use uppercase.

Thanks,
Dave

dbForge for SQL Server build 117
Windows 7 x64
SQL 2008 R2

[hobiedave]

I have tried all your suggestions and they have no effect. The only solution that I found that works is to disable auto completion completely or capitalization of keywords, obviously not really a solution. I suggest you give it a try it yourself.

Type:

SELECT 1 AS [My Group]

See what happens when you hit the ']' Group becomes GROUP even after removing it from the list of completion characters. This is not a completion issue. It is the result of apply the rules of capitalization which should not be applied inside an alias.

[alexa]

You could setup the Code Completion functionality as below:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Text Editor -> Code Completion -> List Members' branch.
3. Remove the ']' character from the 'Following characters' field.

You can also increase or decrease the delay that defines the time after which the suggestion box pops up when you stop typing:

1. Navigate to the 'Text Editor -> Code Completion -> General' branch in the 'Options' window.
2. In the 'Automatically trigger after' field specify the time in milliseconds.

There is also a possibility to turn off automatic displaying of databases, tables, columns, and other database objects in the suggestion list:

1. Navigate to the 'Text Editor -> Code Completion -> General' branch in the 'Options' window.
2. Unselect the 'Auto List Members' option.

Once this option is turned off, the suggestion list can be invoked manually with the help of the 'CTRL+SPACE' combination.

[alexa]

Thank you for the reply.

We were able to reproduce this issue and will fix it in one of the next builds of the product.