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

Formatting / wrapping text configuration not honoured

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

I've got one like so ...
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
steveculshaw
0

Comments

2 comments

Sort by
  • Andy C S
    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 
    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 C S
    0
  • steveculshaw
    Thanks Andy, that works fine
    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 
    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.
    steveculshaw
    0

Add comment

Please sign in to leave a comment.