How to stop indent the BEGIN ... END block?

ogrishman

Hi there,

I want to know if it's possible to disable the indentation of the BEGIN ... END block. Below is a sample code to demo what I want.

USE master;
GO
IF DATABASEPROPERTYEX(N'testdb', N'Version') IS NOT NULL
BEGIN
    ALTER DATABASE testdb SET OFFLINE WITH ROLLBACK IMMEDIATE;
    DROP DATABASE testdb;
END

Thanks.

Aaron L

Hi ogrishman,

I don’t think this is exposed in the UI but you can change this by editing the following file:

%localappdata%\Red Gate\SQL Prompt 6\RedGate_SqlPrompt_Format_Layout_LayoutOptions.xml

And setting <IndentBeginToken> to False.

I'm really sorry this is such an awkward way of setting what should be a common option. I don't know why it isn't in the UI so I'll have a look into seeing if we can put in an extra checkbox for it now.

Thanks,
Aaron.

Eddie D

Hi ogrishman,

A support call has been created for you HERE. You will require a RedgateID to be able to view the support call via your web browser.

Via our call logging system, I have set to you an email with a SQL Prompt Style attached where the indent value has been set to zero. Otherwise all other options are as per the default style. To import the style, please follow the advice in this Help ARTICLE.

Many Thanks
Eddie

Aaron L

I've also exposed the option through the UI in our 6.4 beta which you can download from here.

It's under Tabs & wrapping as "Indent BEGIN…END blocks":

ogrishman

Thanks for adding the checkbox! I've tried the beta version and it works like a charm.