Text color in the QlikView Editor

[marsmike]

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

[alexandros17]

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

[marsmike]

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

[alexandros17]

Yes,

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

while load is related to internal tables (QV)