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.
Table aliases are changed to upper case
Re: Table aliases are changed to upper case
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.
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.
Re: Table aliases are changed to upper case
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.
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.
Re: Table aliases are changed to upper case
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.
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.