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


1 person likes this idea

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

Currently using 10.0.25. I have not seen the beta

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

Brian,


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


Regards


Roger


-----------------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 ...

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

Any update or plan for this?


Thanks,

Brian

Brian,


We will look into it.


Regards


Roger

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

Login or Signup to post a comment