Start a new topic

FormatSQL: Add Line Break before/after semicolon

 Add toggle for add line break before/after semicolon. Allows semicolons to be on their own line if desired, as well as adds ability to put space between queries on same Query Editor page


Brian,


Just to inform you that we have just released a new beta version of the upcoming DbVisualizer 11.0 with a new "Line Break Before Semicolon" setting in the SQL Formatter.



Would be great if you can give it a test to verify that it works properly.


Regards


Roger

Brian,


We will look into it.


Regards


Roger

Any update or plan for this?


Thanks,

Brian

I am realizing that there seems to already be an option to separate queries with an empty line, so "After semicolon" would probably be redundant

-----------------CURRENT-------------------------

SELECT

....

ORDER BY

    col1 ;


--Beginning of new query

SELECT ...


-----------------AFTER-------------------------

Add Toggle to "Line Breaks": Before ";"
SELECT

...

ORDER  BY

    col1

;


--Beginning of new query

SELECT ...

Brian,


Can you please provide a sample showing before and how you would like it to be?


Regards


Roger


Just installed the beta, version 110.3042. Confirmed that semicolon line break is still not present.

Currently using 10.0.25. I have not seen the beta

Brian,


What DbVisualizer version are you using? Have you checked the beta version of the upcoming DbVisualizer 11.0? It includes a new SQL formatting engine. https://www.dbvis.com/beta/


Regards


Roger

Login or Signup to post a comment