Formatting / wrapping text configuration not honoured

Provides intelligent code completion for SQL Server editors.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, justin.caldicott, Aaron Law

Formatting / wrapping text configuration not honoured

Postby steveculshaw » Fri Jun 15, 2012 11:44 am

The formatting option for wrapping text doesn't seem to be working with CTE's ...

I've got one like so ...

Code: Select all
WITH    [DAN_Decision_v4_data] ( [ID], [Decision_ID], [Client_No], [Document_ID], [Proposed_RAS_Allocation], [Carers_Grant_Principal_Carer_Allocation], [Carers_Grant_Secondary_Carer_Allocation], [Annual_Contingency_Allocation], [DAN_Panel_Decision], [Decision_Comments_From_DAN_Panel], [Agreed_Indicative_Weekly_Allocation], [Agreed_Date], [Agreed By], [Reason_For_Moderation], [Detail_Reason_For_Moderation], [Evidence_From_Support_Plan], [Support_Plan_Completed_By], [Final_Decision], [Comments_From_Panel], [Detail_Reason_For_Moderation_RAS_Allocation], [Final_Authorised_Weekly_Budget], [End_Date], [Decision_Form_Version_Number], [Matched_To_Questionnaire], [Decision_Timestamp], [Client_Group], [End_Budget_Date], [End_Budget_Reason] )
          AS ( SELECT   i.[ID] AS [ID] ,

and no matter the Wrap Text setting, it's always reformatted to a single very long line

This is with version 5.3.2.2 of SQL Prompt
Cheers,
SteveC.
steveculshaw
 
Posts: 11
Joined: Tue Jun 02, 2009 9:37 am

Postby andy.campbell.smith » Tue Jun 19, 2012 3:29 pm

You're right, it doesn't seem to like CTEs written like that at all. If you omit the column list and write it like
Code: Select all
WITH    [DAN_Decision_v4_data]
          AS ( SELECT   i.[ID] AS [ID] ,
                        i.[Decision_ID] AS [Decision_ID]
             )
then it seems to format OK - would that work for you in this case? I'll log the inconsistent behaviour with column lists as a bug.
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Re:

Postby steveculshaw » Tue Jun 19, 2012 3:39 pm

Thanks Andy, that works fine

andy.campbell.smith wrote:You're right, it doesn't seem to like CTEs written like that at all. If you omit the column list and write it like
Code: Select all
WITH    [DAN_Decision_v4_data]
          AS ( SELECT   i.[ID] AS [ID] ,
                        i.[Decision_ID] AS [Decision_ID]
             )
then it seems to format OK - would that work for you in this case? I'll log the inconsistent behaviour with column lists as a bug.
Cheers,
SteveC.
steveculshaw
 
Posts: 11
Joined: Tue Jun 02, 2009 9:37 am


Return to SQL Prompt 5

Who is online

Users browsing this forum: No registered users and 1 guest