FULL and COMPLETE syntax for INCLUDE statement

Tue, 13 Jan 2015 14:54:32 GMT

Trying to use this as we are changing db configurations, and I want to keep all the connections in separate Include files, so that I only need to update them once.

I entered in my script:

$(include = R:\IncludeFiles\ActivityDB.txt);

It showed up in italics, with the entire line underlined in red (usually indicates an error!).

Wasn't recognized - that is, script threw up errors that it couldn't access the db

Tried $(Must_Include = R:\IncludeFiles\ActivityDB.txt);; Got the message "Connection failed"

Two things: What is the correct syntax for this command? I followed what was shown in the Help file exactly. Does it need to be

prefaced with something (e.g. the "OLEDB Connect"?).

Second: if anyone from QlikTech is reading this, PLEASE, PLEASE update your documentation search engine!! I suggest that someone try searching for "Include" or "$(Include" or anything, and getting a meaningful result from the search engine. It was only when I tried to search for "Must_Include" that I found the entry.

Re: FULL and COMPLETE syntax for INCLUDE statement

alexandros17 — Tue, 13 Jan 2015 14:59:22 GMT

remove spaces before and after =

$(Include= R:\.......);

I do not know if R drive is recognized, tri with a syntax like

$(Include=..\_Common Code\Source\Variables Main.txt);

Let me know

Re: FULL and COMPLETE syntax for INCLUDE statement

Tue, 13 Jan 2015 15:06:16 GMT

Hi Alessandro,

Thanks very much! Worked perfectly!

topic Re: FULL and COMPLETE syntax for INCLUDE statement in QlikView

FULL and COMPLETE syntax for INCLUDE statement

Re: FULL and COMPLETE syntax for INCLUDE statement

Re: FULL and COMPLETE syntax for INCLUDE statement