Aliases starting with S F W won't work and default to text expansion
Chris_F
Posts: 12 Bronze 1
in SQL Prompt
When trying to write a query with single letter aliases, the keyboard behaviour is different for the letters S, F & W.
Example:
If you press the enter key you will get a new-line, however S will expand to "SELECT, F will expand to "FROM" and W will expand to "WHERE".
When this issue occurs, the suggestion box does not automatically load, so the expansion seems like an error and is a major annoyance when those letters are used as an alias.
There is no way to bypass this expansion, the only way I've found is to type the alias letter followed by a space, then type text on the following line and later go back and remove the space.
What I suggest should happen is the suggestion box should appear on pressing the enter key and the alias be added to the suggestion list as the first option. This allows a double enter key to use the alias.
Example:
Another option is to not auto expand and only allow the expansion if a user selects CTRL+SPACE for those letters.
Example:
SELECT *<br>FROM Table X<b>|</b><br>Where | is the cursor.
If you press the enter key you will get a new-line, however S will expand to "SELECT, F will expand to "FROM" and W will expand to "WHERE".
When this issue occurs, the suggestion box does not automatically load, so the expansion seems like an error and is a major annoyance when those letters are used as an alias.
There is no way to bypass this expansion, the only way I've found is to type the alias letter followed by a space, then type text on the following line and later go back and remove the space.
What I suggest should happen is the suggestion box should appear on pressing the enter key and the alias be added to the suggestion list as the first option. This allows a double enter key to use the alias.
Example:
S<br>SELECT<br>SET<br>SAVE
Another option is to not auto expand and only allow the expansion if a user selects CTRL+SPACE for those letters.
Tagged:
Best Answer
-
Russell D
Posts: 1,324 Diamond 5
Just in case anyone else experiences this it looks like it wasn't due to SQL Prompt but a third party snippet tool that had aliases set up for these letters.Have you visited our Help Centre?
Answers
Have submitted a support request, as well as created a video of it happening.