Red Gate forums :: View topic - Indents on Formatting code inconsistent
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Refactor 1
SQL Refactor 1 forum

Indents on Formatting code inconsistent

Search in SQL Refactor 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
MartinB



Joined: 04 Sep 2009
Posts: 5

PostPosted: Thu Sep 10, 2009 8:17 am    Post subject: Indents on Formatting code inconsistent Reply with quote

Hi when you format code with a sub select the indentation is inconsistent.
I have my indentation set to 4 spaces which when I format most code is OK
But
When I have a sub select in the code it indents the sub select code with only 2 spaces (The formatting below has been done by this page but you get the idea - the indents under the first From are 2 but the indents under the FROM in the sub select is 1 )
If I set my indent to be 4 I expect it to be 4 throughout ALL the code

Code:


SELECT
    *
FROM
    Member m
WHERE
    memberid IN ( SELECT TOP 100
                    memberid
                  FROM
                    member where membername like '%smith')
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Fri Sep 11, 2009 9:40 am    Post subject: Reply with quote

Many thanks for your post Martin.

Can you kindly let us know the expected formatting out put of the query?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
MartinB



Joined: 04 Sep 2009
Posts: 5

PostPosted: Wed Sep 16, 2009 3:38 pm    Post subject: Re: Reply with quote

Anu Deshpande wrote:
Many thanks for your post Martin.

Can you kindly let us know the expected formatting out put of the query?

Hi

I have my indentation set to 4 spaces So for a SELECTstatement I
expect the the begining letter of the column name to allign under the second e of SELECT i.e 4 chars in
Normally this happens OK
but if the select statement is offset to the right on the page as when you are doing a sub select it aligns the field colums under the L of the SELECT.
Hope this makes sense.
I cant display an example here because the rendering of this page appears to have its own formatting rules.
If you want I can email examples.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 688
Location: Cambridge

PostPosted: Thu Sep 17, 2009 1:57 pm    Post subject: Reply with quote

As per our email communication.

I wrote: "Thanks for your prompt reply.

Yes you are right it is inconsistent hence I have logged this as a bug in our internal tracking system SR-855.

So that it can be reviewed by our development team and considered as candidate in our future release.

Thanks for your prompt reply and your feedback it is highly appreciated."
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
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