Devart Forums

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.

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.

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.

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.