Comments
5 comments
-
Hi @marthinus
Can you let us know the previous version number where this works differently? I can raise this to the development team.
You should be able to get it work if you change to Tabs where possible and reformat the script.
-
hi @Tianjiao_Li - thanks for the reply.
I'm currently making use of Version 9.2.3.5933. I'm not exactly sure which version I used previously.
I see you pasted a screenshot with the settings that require changing, but where exactly do I find these settings? I've looked all over but can't find it.
-
Hi @marthinus
I tested this issue again in the latest version. The indentation seems to stay as tab now. Can you please upgrade to the latest version (9.2.6.6145) and let me know if it's still an issue for you?
Thanks! -
hi @Tianjiao_Li
I've upgraded to the latest version (9.2.6.6145) - however - I still don't know where to find the settings that you highlighted in your screenshot in your first reply.
the settings appear to be missing from my SQL Prompt - can you please show me where you find your settings so I can confirm whether the settings is missing for me or not.
-
Hi @marthinus
Sorry for the delay. The screenshot in my previous reply was from formatting style.
https://documentation.red-gate.com/sp9/formatting-your-code
https://documentation.red-gate.com/sp9/formatting-your-code/using-styles
Add comment
Please sign in to leave a comment.
when making use of auto-complete eg. pressing tab button when cursor is right after the asterisk in the following snippet:
SELECT
TBL.*
FROM tablename AS TBL
replaces the column list in the snippet with the full list of column names, such as:
SELECT
TBL.col_1,
TBL.col_2,
...,
TBL.col_n,
FROM tablename AS TBL
however, the indentation is spaces, not tabs as I prefer
I can't find a setting for this in SQL Prompt settings, is there one? a previous version I used didn't work like this, I see this matter was raised before SP-1329, (https://forum.red-gate.com/discussion/11637/format-styles-tabs-vs-spaces)
can anyone assist?