What are the challenges you face when working across database platforms? Take the survey
Options

Line Return Indentation Issue

MBBWMBBW Posts: 16
edited March 14, 2011 9:28AM in SQL Prompt Previous Versions
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

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
  • Options
    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
    
  • Options
    Anu DAnu D Posts: 876 Silver 3
    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
Sign In or Register to comment.