Table aliases are changed to upper case

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
dsmidgy
Posts: 4
Joined: Wed 12 Jun 2019 06:24

Table aliases are changed to upper case

Post by dsmidgy » Fri 20 Mar 2020 15:35

Hi. When I write a "SELECT * FROM TableM m ON m.columnName" the "m" before ".columnName" changes to upper case "M". And I see that I don't have any objects named "M". I use SQL Complete.
Do you have any idea why is this happening?

Thank you for your answer, D.

alexa
Devart Team
Posts: 2890
Joined: Fri 24 Jun 2011 14:17

Re: Table aliases are changed to upper case

Post by alexa » Mon 23 Mar 2020 09:18

This can be setup in the 'Text Case -> Alias Case' section of the 'Edit Formatting Profile' window that can be opened as follows:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Open Selected...' button.

dsmidgy
Posts: 4
Joined: Wed 12 Jun 2019 06:24

Re: Table aliases are changed to upper case

Post by dsmidgy » Wed 01 Apr 2020 10:50

I set the mentioned setting to lower case. And it still doesn't work. It would always be corrected to upper case.
You must first press "m" and then "." - then the "m" changes to "M".
If you type "m" without "." and select the column from the menu, it works OK.

alexa
Devart Team
Posts: 2890
Joined: Fri 24 Jun 2011 14:17

Re: Table aliases are changed to upper case

Post by alexa » Thu 02 Apr 2020 14:30

Thank you for the reply.

We were able to reproduce this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

Post Reply