Formating Select Statement Combines 'as' With The Field Name

• 

  RogueDog wrote:

  I have found that when using the keyword 'as' in the select statement, and the statement is formated using your tool, in all of the instances past the first field the 'as' is combined with the field name.
  Example:

  Select c.Company_Id as id, c.Company_Name as Name, c.Address_1 as address, c.State_, c.City
  from dbo.Company c
  
  Select   c.Company_Id as id
          , c.Company_Nameas Name
          , c.Address_1as address
          ,c.State_
          ,c.City
  from     dbo.Company c
  

  
  I have also found that it is does not matter if 'as' is used in the first field or not, every 'as' after that first field is combined in with the field name.
  
  Looking at this closer I noticed that the space that should immediatly precede the 'as' is placed in front of the field name. I use a formating that has the comma's in front of the field name
  
  I found this when reformating some old views, but it does this with any select statement I have tried.

  
  
  Hi,
  
  This was indeed a bug in the beta, however this we have fixed in the final release. Many thanks for reporting this. Now the above example does work properly on my internal build. But, to make even more sure that it will work for you, could you tell me what options you are using, and whether you have experienced similar problems with other statements. Please keep reporting these issues, there is still time to fix them before the 1.0 release
  
  Regards,
  Andras

  Andras B October 20, 2006 03:26

  - 0 +
• 
  Here are my settings. I have listed those items that I have checked.
  

  General
  	Commas
  		Space after comma
  		Place Commas at Start
  			Allign to lists
  	Indentation
  		Characters to indent 4
  	Wrapping
  		Characters per line 60
  	Spaces
  		(Unchecked)
  Expressions
  	Operator placement
  		On a new line
  			Place operator at start
  	Operator spacing
  		Surround with spaces
  		Surround with spaces
  	Parentheses placement
  		(Nothing Checked)
  	Parentheses contents
  		Indent contents of parentheses
  Schema Statements
  	Definition placement
  		(Nothing Checked)
  Data statments
  	Subquery placement
  		(Unchecked)
  	Column placement
  		(Unchecked)
  	Parentheses placement
  		(Unchecked)
  	Join Placement
  		Align JOINS with FROMS
  		Place join conditions on a new line
  			Align join conditions with join keyword
  

  
  This particular issue happens with any select statement. I will keep an eye out for other issues and post them as I find them.

  RogueDog October 20, 2006 10:29

  - 0 +
• 

  RogueDog wrote:

  Here are my settings. I have listed those items that I have checked.
  ...
  This particular issue happens with any select statement. I will keep an eye out for other issues and post them as I find them.

  
  Many thanks for sending these. I can reconfirm that it is fixed . Many thanks for your help,
  Regards,
  Andras

  Andras B October 20, 2006 10:39

  - 0 +

Add comment

Please sign in to leave a comment.