Red Gate forums :: View topic - Formatting / wrapping text configuration not honoured
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 5
SQL Prompt 5 forum

Formatting / wrapping text configuration not honoured

Search in SQL Prompt 5 forum
Post new topic   Reply to topic
Jump to:  
Author Message
steveculshaw



Joined: 02 Jun 2009
Posts: 11

PostPosted: Fri Jun 15, 2012 11:44 am    Post subject: Formatting / wrapping text configuration not honoured Reply with quote

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.
Back to top
View user's profile Send private message
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Tue Jun 19, 2012 3:29 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
steveculshaw



Joined: 02 Jun 2009
Posts: 11

PostPosted: Tue Jun 19, 2012 3:39 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group