topic Oracle and SQLServer uppercase fields error in QlikView

Oracle and SQLServer uppercase fields error

Fri, 27 Apr 2012 13:03:55 GMT

Hi,

I have a QlikView project that hava to connect Oracle or SQLServer, the sql sintax is the same in both cases.

When I connect to Oracle, the first SQL sentence is

SQL select apellido1, apellido2, nombre from personal;

In oracle i receive the fields like:

APELLIDO1

APELLIDO2

NOMBRE

And in SQLServer

apellido1

apellido2

nombre

So there is a case difference, and all the object giving me errors cause that. The fields in database are in lower case, why in oracle give me in uppercase and in SQLServer in lowercase¿? there is a way to receive the field in the same "format" ¿?¿?¿?¿

Thanks...

Oracle and SQLServer uppercase fields error

hic — Fri, 27 Apr 2012 17:13:46 GMT

QlikView does nothing to change what it gets from ODBC or OLE DB. I do not know the Oracle driver well, but you need to check your settings on the Oracle ODBC data source (or OLE DB data provider). Maybe there is a setting there?

HIC

Oracle and SQLServer uppercase fields error

Fri, 27 Apr 2012 19:57:40 GMT

Waht you can do is rename the fields

APELLIDO1 as apellido1

APELLIDO2 as apellido2

NOMBRE as nombre

Luciano.-