Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

andriesb
Contributor

is ".Status" a reserved word?

I used to read a DBF file via ODBC, but as soon as I name one field is named 'Status' I get an ODBC error.

if (AANWEZIG ='0', 'In depot',
if (AANWEZIG ='1', 'Verhuurd', ''))    AS Container.Hist.ContStatus,

   

if (AANWEZIG ='0', 'In depot',

if (AANWEZIG ='1', 'Verhuurd', ''))    AS Container.Hist.Status,

The second option would result in an "OBDC read failed" error. When changed to Container.Hist.Status2 it works fine.

Is the word ".Status" a reserved work in any case? Would the period 'matter'; I though  the period would help to define a unique name.

P.s.

AANWEZIG   AS Container.Hist.Status,

would result in the same eror. The problem is not in the equation.

Community Browser