SQLinForm SQL FormatterCommunity Discussion Forum
SQLinForm SQL Formatter
Would love an option to have 0 values on the first line SQL>SQL Lists > # Vals on Line 1 (effectively forcing a newline). This along with some other formatting options before/after will make custom formatting more extensible for keywords that are not actively supported right now.
Hi @nicholasd, thanks for your feedback. Which DB are you working with and could you please one example
Thanks
Guido
@Guido
I am working with Snowflake in Dbeaver. A simple example is below:
--------------------
-- CURRENT FORMAT --
--------------------
SELECT
-- Number of Values line 1 = 2
-- Number of Values line 2 = 2
CONCAT( 'String1', ', '
, 'STRING2', ', '
, 'STRING3', ', '
, 'STRING4'
)
----------------------
-- PREFERRED FORMAT --
----------------------
-- Number of Values line 1 = 0
-- Number of Values line 2 = 2
SELECT
CONCAT(
'String1', ', '
, 'STRING2', ', '
, 'STRING3', ', '
, 'STRING4'
)
OK, I will add an option for linebreaks before/after the bracket and to indent the values like in the screenshot for keyword1, keyword2 and keyword3
Hi @nicholasd,
it took some time but now your idea is available for N++ Plugin and Stand-Alone App
Regards
Guido
Hi Guido,
I have the opposite issue.
I use the VSCode plugin and configured following setting:
but I get following result:
Could you help me?
Thank you
Hi @sardfox ,
thanks for your feedback. I cannot see the issue, it looks fine for me. Which format did you expect?
Are you working with the free or Pro Version?
REgards
Guido
Hi Guido,
I'm working with the Pro Version.
Following the expected result:
Let me know if you need more details.
Thank you
could you please goto
and delete the SQLinForm Options. exit VSCode, start VSCode again and try again
