5 results found
-
format: db Identifier case issue,it does not work for similarly named columns
When you format text based on
Text Case > Identifier Case > As in database
It does not work as expected.
e.g. supposedly i have some tables definitionsCREATE TABLE DUCK1(Abc int)
CREATE TABLE DUCK2(aBc int)CREATE TABLE DUCK3(abC int)
I these are the statements i want to format
select d.abc from duck2 as d
select d.abc FROM duck3 as d
but what i get after formatting is this
SELECT d.aBc FROM DUCK2 AS d
SELECT d.aBc FROM DUCK3 AS dthis is not what was expected.
4 votesIn case there are multiple objects with different case in the database, dbForge remembers the case of the first found identifier in the database and uses it for all identifiers with this name.
-
table alies prefix in pivot wrong
When using PIVOT the columns are prefixed with the table alias of the table inside of the pivot and nog with the alias of the pivot
2 votes -
UPDATE statement expansion has "WHERE ID = DEFAULT" as the WHERE clause
"WHERE ID = DEFAULT" is not a valid WHERE clause
1 vote -
Add ability deleting formatting profiles
The point 'Delete' is disable in the context menu in
SQL Complete->Options->Formatting->Profiles1 vote -
Suggest joins for columns from cross/outer apply
When doing a join on a table to a cross/outer apply function, intellisense doesn't suggest any joins based on column names like it does for joins on tables/views
1 vote
- Don't see your idea?