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. 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.
-
AdminDevart (_, Devart) commented
> 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.