How to keep a subquery for an IF on a single when formatting?

[Thenrich]

I have this statement:

Code: Select all

IF (NOT EXISTS (SELECT  1 FROM customer WHERE CustomerId = 1  ) )
  BEGIN
  END

and every time I format the code, I get this:

Code: Select all

  IF (NOT EXISTS (SELECT
      1
    FROM customer
    WHERE CustomerId = 1)
  )
  BEGIN
  END

I don't see an option under IF formatting to keep subqueries in single line. I have changed several options and nothing works.

[alexa]

Please perform the following:
1. Select 'SQL Complete -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Formatting -> Profiles' branch.
3. Select the active profile and click the 'Edit Profile...' button.
4. Navigate to the 'Subquery -> Single line -> ALL, ANY, SOME, EXISTS operators' node.
5. Select the 'Any subquery' option.