Devart Forums

Hi,

is there a way to force UniDac to "uppercase" all field names in result datasets?

cu Christian

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

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

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