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

ogrishman · August 15, 2014 2:31PM

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&#40;N'testdb', N'Version'&#41; IS NOT NULL
BEGIN
    ALTER DATABASE testdb SET OFFLINE WITH ROLLBACK IMMEDIATE;
    DROP DATABASE testdb;
END

Thanks.

Aaron L · August 18, 2014 4:44AM

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 · August 18, 2014 9:39AM

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 · August 18, 2014 10:32AM

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 · August 18, 2014 10:33PM

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

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

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk