278 results found
-
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…1 vote> 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.…
-
stacking indent when using "if else if"
when i want tu format if else if block i want to get someting like this :
if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
endBut best what i can do is this stacking indent behavior:
if (1 = 1)
begin
set @avgweight = (select
AVG(Weight)
from Production.Product);
end else
…if (1 = 1) begin set @avgweight = (select AVG(Weight) from Production.Product); end else if (1 =1 vote -
Formatting Profiles: add ability to use spaces for indentation
Indentation using tabs highly dependent on the settings tab size
1 vote -
1 vote
-
1 vote
-
Add feature to format code using different styles defined by user previously
Now it can format code using only one selected style
1 voteYou can now quickly change formatting profiles in the popup menu ‘Active Format Profile’.
-
1 vote
Please perform the following:
1. Select ‘SQL Complete → Options’ from the main menu. The ‘Options’ window opens.
2. Navigate to the ‘Formatting → Profiles’ branch.
3. Right-click in the ‘Formatting Profiles’ section and select ‘Reset To Defaults’ from the popup menu. -
In Argentine People can't buy sql Complete
In Argentine by sql complete is imposible, one dollars are 8 pesos. Is realy expensive!! Also, I can't write in a blog about sqlcomplete because I only use it one free month and then I have to unistall it. I don't use linkedin or facebook, so I can't have this excelent tool. I hate people who download pirate things, so I won't dowload it in http://thepiratebay.se
Maybe, if I start to use it in my work (complete version six months), other people who can buy it like this excelent tool and they'd buy it.1 vote -
Enable/disable Key combination
A key combination to enable/disable SQL Complete would be extremely useful simply for those circumstances where it just gets in the way like when you are working on a system with hundreds of databases and they appear in the suggestions. Tony
1 vote -
Segment Formatting
when having multiple nested Select Statements, it formats based on the top-most parent Select statement instead of, either the encapsulated statement or the Select keyword.
Potential idea: If there is a Select keyword, indent appropriate its siblings but if a nested select is included inside one of the sibilings then base its indention key off the new select pattern, and so on.
For example:
Select
Field1,
Field2,
( Select
Field3,
Field4,
From Table2 ) as Field_5
From Table11 vote -
Bug: Stack table view doesn't apply to variable assignments
see sample code below
Select
@Variable1 = d
,@Var2 = dsfdasf
From
#data1 vote -
Display Synonyms
Display synonyms as tables
1 vote -
Allow user to disable automatic close parenthesis functionality
At some point SQL Complete was modified to automatically close parenthesis when writing functions. When I type 'sum(' the close paren is automatically added and the cursor placed within the parens. This forces me to resort to using the arrow keys when I am done supplying the function's arguments. I don't type with arrow keys, and would like the ability to disable this functionality.
1 voteThere is a setting ‘Add parentheses when inserting function’.
-
Need ability to give intelliSense for store procedure parameter
I am big fan of this SQL Complete tool, it is really a good tool to help develop or build sql blocks. But one thing i notice that, currently sql complete is not providing intellisense for store procedure parameter. if it is providing this thing also than its really help full while building store procedure.
1 vote -
Add a lowercase option in the SQL Formatter
Redgate has this, infact many of the online SQL formatters give you the option to have keywords, etc as lowercase, capital or uppercase.
Your product is reasonably priced against redgate.
But it's unusable if it makes all my keywords uppercase.
Thanks,
Jason1 voteThis 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 the active profile.
4. Click ‘Edit Profile…’. The ‘Edit Profile’ window opens.
5. Expand the ‘Text Case’ node.
6. Expand the appropriate subnode and select the ‘Lower’ radio button. -
If the word I manually type matches an autocomplete entry, apply the case in the AutoComplete to the typed word.
If the word I manually type matches an AutoComplete entry, apply the case in the AutoComplete to the typed word. This would apply to both reserved words and object names.
Example 1: I type 'sel' and wait a millisecond. 'SELECT' appears in the AutoComplete. I press [space] and SELECT is typed for me. Next, I type 'select' and press [space] without waiting. The word remains lower case.
Example 2:I type 'select * from peo' and wait a millisecond. 'People' (a table name) appears in the AutoComplete. I press [space] and 'People' is typed for me. Next, I type I type…
1 vote -
Format rule for CREATE TABLE
Need a format rule for CREATE TABLE.
1 vote -
ability to create some snniped
ability to create some snniped
1 voteThe Code Snippets feature is available in the fully featured 30-day Trial version of the Standard Edition of dbForge SQL Complete http://www.devart.com/dbforge/sql/sqlcomplete/download.html
-
1 vote
-
Support formatting for @tbl_Table
Please add support for formatting table variable like other table similar format:
Declare @tbl_MyTable Table (
Id int,
Code nvarchar(50)
)1 vote
- Don't see your idea?