What are the challenges you face when working across database platforms? Take the survey

Aliases starting with S F W won't work and default to text expansion

Chris_FChris_F Posts: 12 Bronze 1
When trying to write a query with single letter aliases, the keyboard behaviour is different for the letters S, F & W.

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.


Another option is to not auto expand and only allow the expansion if a user selects CTRL+SPACE for those letters.


Best Answer

  • Options
    Russell DRussell 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?


Sign In or Register to comment.