Identifier case issue
Posted: Mon 29 Dec 2014 02:27
Hi,
I use SQL Complete on case sensitive databases. As the column aliases become column titles in our software interface, I have to deal daily with queries such as:
The problem is that when I run code formatting on this with the identifier case set to "As in the database", it becomes:
The query then fails as it should be sc.NAME. Even without the aliasing of columns, SQL Complete gets confused if another table in the database has the same column name in a different case. You can view the issue with this kind of query:
which gets formatted as:
It has become quite an issue lately as I need to run queries on databases with different cases for the column names, so I can't use SQL formatting on these queries. Am I doing something wrong?
My setup is as follows, "Identifier Case" is set to "As in the database":
I use SQL Complete on case sensitive databases. As the column aliases become column titles in our software interface, I have to deal daily with queries such as:
Code: Select all
select sc.NAME as [Name]
,sc.[DESCRIPTION] as [Description]
,sc.DATATYPE as [Data Type]
,sc.SCUNITS as [Units]
from SAMPLECODE as sc
order by sc.NAMECode: Select all
select sc.Name as [Name]
,sc.[Description] as [Description]
,sc.DATATYPE as [Data Type]
,sc.SCUNITS as [Units]
from SAMPLECODE as sc
order by sc.NameCode: Select all
select sc.NAME
,sc.[DESCRIPTION]
,sc.DATATYPE
,sc.SCUNITS
from SAMPLECODE as sc
join (
values ('A name')
) as vals (name)
on vals.name = sc.NAME
order by sc.NAMECode: Select all
select sc.name
,sc.[DESCRIPTION]
,sc.DATATYPE
,sc.SCUNITS
from SAMPLECODE as sc
join (
values ('A name')
) as vals (name)
on vals.name = sc.name
order by sc.nameMy setup is as follows, "Identifier Case" is set to "As in the database":