| Author |
Message |
MartinB
Joined: 04 Sep 2009
Posts: 5
|
 Posted: Thu Sep 10, 2009 8:17 am Post subject: Indents on Formatting code inconsistent |
 |
|
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 |
|
 |
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Fri Sep 11, 2009 9:40 am Post subject: |
|
|
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 |
|
|
MartinB
Joined: 04 Sep 2009
Posts: 5
|
| Posted: Wed Sep 16, 2009 3:38 pm Post subject: Re: |
|
|
| 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 |
|
|
Anu Deshpande
Joined: 20 Apr 2009
Posts: 590
Location: Cambridge
|
| Posted: Thu Sep 17, 2009 1:57 pm Post subject: |
|
|
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 |
|
|
|
|
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
