How can we help you today? How can we help you today?

List "new line" behaviour not consistent with TOP operator

Under Global --> Lists --> List Items, I have the "Place first item on new line" option set to "if there are subsequent items" (note: brief test shows the same issue applies when this is set to "always").

With a normal multi-column query, this works fine: 
SELECT
	1 AS x -- this is nice
   ,2 AS y
   ,3 AS z

However, if I include the TOP operator, this breaks: 
SELECT TOP 1 1 AS x -- wrong spot!! Arrgh!
   ,2 AS y
   ,3 AS z

I would expect the List items setting to work consistently for columns, regardless of the presence or absence of the TOP operator: 
  SELECT TOP 1
	1 AS x -- yes yes yes
   ,2 AS y
   ,3 AS z
a.higgins
0

Comments

2 comments

Sort by
  • a.higgins
    For fun, I just tried the 'DISTINCT' keyword and it works fine: 
    SELECT DISTINCT
	1 AS x -- yes yes yes
   ,2 AS y
   ,3 AS z
    a.higgins
    0
  • David Priddle
    Hi a.higgins,

    The top clause has caused us quite a few problems. We'll look into getting this sorted.

    It is possible to get this behaviour you want by setting the following option:

    WuczfWd.png

    This won't keep it one line if there are multiple items, but you could combine this with the "Collapse statements shorter than x characters" option.

    If this doesn't work for you, I'll take a look to see if the options could be reworked.

    Best regards,

    David
    David Priddle
    0

Add comment

Please sign in to leave a comment.