Line Return Indentation Issue

MBBW

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

Anu D

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?

MBBW

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.

SELECT *
	FROM 
	| <-- cursor position
	

-- I need this behaviour:
SELECT *
	FROM 
| <-- cursor position

Anu D

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.