Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Bug: Line breaks removed before comments

New lines are removed between a parentheses or a comma and a comment.

see sample below.

Select * From(
Select 1 a

,

        --comment after comma - rows above removed



        2 t


        --comment after field - rows above not removed
        ,


        --sdf


        3 g) 

        /*comment after parentheses - rows above not removed*/


        a
5 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Joel Brown shared this idea  ·   ·  Report…  ·  Admin →
completed  ·  AdminDevart (_, Devart) responded  · 

> New lines are removed between a parentheses or a comma and a comment.
> see sample below.
> Select * From(
> Select 1 a
> ,
> —comment after comma – rows above removed

This issue is fixed in the latest build 4.0.78: http://www.devart.com/dbforge/sql/sqlcomplete/download.html

> 2 t
> —comment after field – rows above not removed
> ,
> —sdf

This issue is fixed in the latest build 4.0.78.

> 3 g)
> /comment after parentheses – rows above not removed/
> a

Such behavior is currently by design. Though, you can carry this issue over to a new suggestion.

Show previous admin responses (1)

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Joel Brown commented  ·   ·  Report

    Posting corrected code.

    Select * From(
    Select 1 a

    ,

    --comment after comma - rows above removed

    2 t

    --comment after field - rows above NOT removed which is correct
    ,

    --sdf

    3 g)

    /*comment after parentheses - rows above removed*/

    a