Lower case becomes upper case?

[#1]

Hi, I am new to QV and I have a problem when writing script in the script editor. When I for example write Date, it turns out as DATE and hence gives me problems when I want to use it as key. I have tried to use the Edit functions to change it but have not managed, my best guess is that there is a setting somewhere that needs to be changed. Someone who knows?

Thank you in advance

[hic]

There is nothing in QlikVIew that would do this. But I have seen ODBC drivers that returns field names in UPPER case no matter what you write in the script...

Is it in a SELECT statement or in Load statement?

HIC

[#3]

It is in a select statement

//Emelie

Från: Henric Cronström

Skickat: den 19 mars 2013 23:10

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by Henric Cronström<http://community.qlik.com/people/hic> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324007#324007>

[Anonymous]

it do not happens automaticall unless you rename a field

date as DATE?

are not you using UPPER Function?

Regards,

anant

[sushil353]

Please post your sample application

[#6]

Hi

My select statement looks like this

ODBC CONNECT TO MOVEX_MVXCDTAAPRD (XUserId is bXKNaVFMWDbSGRB, XPassword is bXcIUURNWLYWGED);

SQL SELECT EZACQT,

EZACTY,

EZAIT1,

EZAIT2 as Division,

EZAIT3 as Avdelning,

EZAIT4,

EZAIT5 as Orsakskod,

EZAIT6,

EZAIT7 as Ordernummer,

EZANBR,

EZCHID,

EZCHNO,

EZCONO,

EZDIVI,

EZERCD,

EZEVEN,

EZFACI,

EZFSRC,

EZITNO as Artikelnummer,

EZLMDT,

EZLMTS,

EZRGDT,

EZRGTM,

EZSENO,

EZTFAM,

EZTRDT as Date,

EZVONO,

EZVSER,

EZYEA4,

EZACAM as Belopp

FROM KAVLI.M3EDBPRD.CINACC

WHERE EZYEA4=2013 AND EZAIT1='4061' AND EZDIVI='020' AND EZEVEN='MM020'

But in the Table viewer it becomes upper case and to key with MITMAS I had to change Artikelnummer in MITMAS to upper case

Från: sushil kumar

Skickat: den 20 mars 2013 12:46

Till: Emelie Nilsson

Ämne: - Re: Lower case becomes upper case?

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Lower case becomes upper case?

created by sushil kumar<http://community.qlik.com/people/sushil353> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/324265#324265>

[hic · Accepted solution]

This means that your ODBC driver always returns upper case. If you want lower case you will need to use a preceding load (See http://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load)

HIC