Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Formatting Source Code (Ctrl K,D)

I like Formatting source code, but for some keywords it not work fine me and make me irritate. The Following are the suggestion regarding Auto Formatting of Code on K, D in SQL.
1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.
2. Ctrl + K,D does not format IF and UNION keyword. It should be like it is working for CASE WHEN THEN END statement.
3. When we add new table / view / sp Intellisense does work on current open window. I try on new query window but i dont found new SP / Table / View / Column. to do it work i have to run new instance of complete SQL.
Please work on above points.

1 vote
Vote

We're glad you're here

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

> 1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.

You were using an old version of the product. Please upgrade dbForge SQL Complete to the latest version 4.0.55 where the issue is fixed: http://www.devart.com/dbforge/sql/sqlcomplete/download.html

Please note that you can setup dbForge SQL Complete as follows:

1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select a profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Select the ‘Text Case → Identifier Case’ branch.
6. Select one of the options.

> 2. Ctrl + K,D does not format IF and UNION keyword. It should be like it is working for CASE WHEN THEN END statement.

You might be using the Express Edition. Please install the Trial Edition where it can be setup as follows:

1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Select a profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Code → IF’ branch.
6. Select needed options.
7. Expand the ‘UNION, EXCEPT, INTERSECT’ branch.
8. Select needed options.

> 3. When we add new table / view / sp Intellisense does work on current open window. I try on new query window but i dont found new SP / Table / View / Column. to do it work i have to run new instance of complete SQL.

To refresh SQL Complete suggestion list, you have to select ‘SQL Complete → Refresh Local Cache’ from the main menu after the changes in the database were applied. We did it in this way for best performance reason.

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
  • AdminDevart (_, Devart) commented  ·   ·  Report

    > 1. in current build on press on Ctrl + K,D all variable name become lower case. We are using camel / pascal notation in our DB. and when we press auto format key, it change all our table / view / column etc names. It remove pascal / camel notation.

    You were using an old version of the product. Please upgrade dbForge SQL Complete to the latest version 4.0.55 where the issue is fixed: http://www.devart.com/dbforge/sql/sqlcomplete/download.html

    Please note that you can setup dbForge SQL Complete as follows:

    1. Select 'SQL Complete -> Options' from the main menu. The 'Options' window opens.
    2. Navigate to the 'Formatting -> Profiles' branch.
    3. Select a profile.
    4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
    5. Select the 'Text Case -> Identifier Case' branch.
    6. Select one of the options.

    > 2. Ctrl + K,D does not format IF and UNION keyword. It should be like it is working for CASE WHEN THEN END statement.

    You might be using the Express Edition. Please install the Trial Edition where it can be setup as follows:

    1. Select 'SQL Complete -> Options' from the main menu. The 'Options' window opens.
    2. Navigate to the 'Formatting -> Profiles' branch.
    3. Select a profile.
    4. Click 'Edit Profile...'. The 'Edit Profile' window opens.
    5. Expand the 'Code -> IF' branch.
    6. Select needed options.
    7. Expand the 'UNION, EXCEPT, INTERSECT' branch.
    8. Select needed options.

    > 3. When we add new table / view / sp Intellisense does work on current open window. I try on new query window but i dont found new SP / Table / View / Column. to do it work i have to run new instance of complete SQL.

    To refresh SQL Complete suggestion list, you have to select 'SQL Complete -> Refresh Local Cache' from the main menu after the changes in the database were applied. We did it in this way for best performance reason.