7 Replies Latest reply: May 10, 2012 1:46 AM by 638078 RSS

    SQL Formatter questions...

    638078
      Hello,

      I have 2 questions/feature requests for the SQL formatter.

      1) I think leading-comma formatting is quite regular, but it seems not to be properly supported by the formatter. What I think it should be is the following:

      SELECT field1
      ,field2
      ,field3
      FROM table;

      But the oly things you can accomplish is either this (by checking only "Line breaks"/"Before comma"):
      SELECT field1
      ,field2
      ,field3
      FROM table;

      or this (by checking both "Line breaks"/"Before comma" and "Line breaks"/"After comma"):
      SELECT field1
      ,
      field2
      ,
      field3
      FROM table;

      2) It would be practical to be able to only use leading comma formatting in the SELECT fields, not in GROUP BY, ... as it isn't quite needed there...

      Regards,
      the_roggy