topic Re: Text color in the QlikView Editor in QlikView

Text color in the QlikView Editor

marsmike — Tue, 08 Apr 2014 11:10:58 GMT

I am seeing non consistent text color in my script editor. I have checked the editor preferences and don't see anything unusual there. As an example, the words "From" and "Where" show up in blue when the script loads from a local table file; when the script pulls from my Oracle database, those words are in black.

While the script appears to work regardless of the text color, my concern is that I do not have QlikView set up properly and if I don't, I could (I am!) experience other issues.

So the simple question is: why do the words "From" and "Where" appear in black when connecting to my Oracle database but in blue when connecting to local table files?

Thanks,

Mike

Re: Text color in the QlikView Editor

alexandros17 — Tue, 08 Apr 2014 11:22:09 GMT

Because Load and Where are "Reserved" keywords for Qlik that recognize them as own instruction.

Load and where in SQL syntax are "External" instruction

Hope it helps

Re: Text color in the QlikView Editor

marsmike — Tue, 08 Apr 2014 11:43:52 GMT

So "SQL Select" is an internal instructions, while "Load" is an internal QV instruction?

Re: Text color in the QlikView Editor

alexandros17 — Tue, 08 Apr 2014 11:47:16 GMT

Yes,

SELECT (you can omit SQL) depends on connection with DB

while load is related to internal tables (QV)