Hi,
is there a way to force UniDac to "uppercase" all field names in result datasets?
cu Christian
Upper case identifier
Re: Upper case identifier
hello,
When adding fields (ADD ALL FIELDS), the fields are added in such case as they are stored at a server. So, if you need your fields to be uppercase, you should just create them uppercase.
Automatic case change at fields adding is not supported.
P.S. Please explain the need of changing the field names to uppercase
When adding fields (ADD ALL FIELDS), the fields are added in such case as they are stored at a server. So, if you need your fields to be uppercase, you should just create them uppercase.
Automatic case change at fields adding is not supported.
P.S. Please explain the need of changing the field names to uppercase
-
chkaufmann
- Posts: 82
- Joined: Sat 01 Jul 2006 11:42
Re: Upper case identifier
In my library there are some checks on field names and these are not case sensitive. Normally we create all DB fields in upper case letters, but now I use the library to access an "external" database where field names are uppercase as well, but for one customer, they have lowercase fields. It's an Esri ArcSDE GeoDatabase.
cu Christian
cu Christian
Re: Upper case identifier
hello,
As I wrote you before, automatic DB field names reduction is not supported, therefore you should correct your checkings, so that they would be case-insensitive, or reduce the field names to upper-case directly in the query, i.e.
Select ArcSDE as ARCSDE from table
As I wrote you before, automatic DB field names reduction is not supported, therefore you should correct your checkings, so that they would be case-insensitive, or reduce the field names to upper-case directly in the query, i.e.
Select ArcSDE as ARCSDE from table