Line Return Indentation Issue

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson

Line Return Indentation Issue

Postby MBBW » Tue Mar 08, 2011 1:45 pm

Hello,

using SSMS 2008 R2, I had to upgrade from SQL Prompt 3.1 to SQL Prompt 3.9.0.43 and now I have the indenting bug on starting a new line described in the SQL Prompt 4.0 forum:

http://www.red-gate.com/messageboard/vi ... hp?p=33988

Didn't you fix this bug in the latest SQL Prompt 3 version?

Thanks
MBBW
 
Posts: 12
Joined: Tue Mar 08, 2011 1:36 pm

Postby Anu Deshpande » Wed Mar 09, 2011 3:50 pm

Many thanks for your post and apologies for inconvenience caused.

This issue was addressed in SQL Prompt 4.

Can you kindly let me know an example explaining the issue that you have in 3.9?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby MBBW » Wed Mar 09, 2011 6:05 pm

First, I am sorry but I wanted to refer to this topic and not the one linked in my first post.
http://www.red-gate.com/messageboard/vi ... php?t=9691

In SQL Prompt 3.1 the default behaviour (in my reminiscence) was that the cursor always started at the first position in the new line – independent of the indention of the line above. With SQL Prompt 3.9 each new line starts at the position the level above is indented.

There is no difference whether I enable or disable this setting:
Inserted Candidates -> Formatting -> Insert new line at current indentation level

If I disable SQL Prompt I do not have this block formatting behaviour.

Example:
In the query below, when I press the return key after FROM the next line is automatically indented at the same level as the line above. But I want the cursor position at the first position of the next line.

Code: Select all
SELECT *
   FROM
   | <-- cursor position
   

-- I need this behaviour:
SELECT *
   FROM
| <-- cursor position
MBBW
 
Posts: 12
Joined: Tue Mar 08, 2011 1:36 pm

Postby Anu Deshpande » Mon Mar 14, 2011 2:28 pm

Many thanks for your reply.

This issue is not yet fixed and it is logged in our internal tracking system whose tracking Id as per the post is SP-2836.

I will update this post as soon as it is fixed.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests