use tabs for auto indentation

marthinus

I'm using SQL Prompt version 9.2.3

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?

Tianjiao_Li

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.

marthinus

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.

Tianjiao_Li

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!

marthinus

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.

Tianjiao_Li

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