What are the challenges you face when working across database platforms? Take the survey
Options

V8 can't seem to format like my old V7

EugeneMEugeneM Posts: 2 New member
I had formatting set for DML to be like:
INSERT into #temp(a, b, c)
  SELECT A, B, C
    FROM TableX
    WHERE A = 'abc'

notice that I indent the from and the where 2 spaces from the alignment. If I set clause alignment to "to statement" and set clause indention to 2... it is kind of close but it doesn't seem to take inserts into account... so the select, from, where after the insert all align to the insert, not the select.
INSERT into #temp(a, b, c)
  SELECT A, B, C
  FROM TableX
  WHERE A = 'abc'

Any assistance? This will start to cause issues as every time that I edit existing code and reformat, it will trigger a huge number of changed lines if we compare version in version control history.
Tagged:

Comments

  • Options
    Jessica RJessica R Posts: 1,319 Rose Gold 4
    Thanks for your post!

    This appears to be working correctly in v8.0.2.1508. Can you kindly update from Help>Check for updates and then try this again?

    Please let us know if any problems persist.

    Jessica Ramos | Product Support Engineer | Redgate Software

    Have you visited our Help Center?


Sign In or Register to comment.