steveculshaw
Joined: 02 Jun 2009
Posts: 10
|
 Posted: Fri Jun 15, 2012 11:44 am Post subject: 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 ...
| Code: |
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. |
|
andy.campbell.smith
Joined: 20 Oct 2011
Posts: 124
Location: Red Gate Software
|
| Posted: Tue Jun 19, 2012 3:29 pm Post subject: |
|
|
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: |
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 |
|
steveculshaw
Joined: 02 Jun 2009
Posts: 10
|
| Posted: Tue Jun 19, 2012 3:39 pm Post subject: Re: |
|
|
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: |
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. |
|
