V8 can't seem to format like my old V7
EugeneM
Posts: 2 New member
in SQL Prompt
I had formatting set for DML to be like:
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.
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.
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
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?