topic Re: What does "Can Execute External Programs" in Settings tab of Edit Script do? in QlikView

What does "Can Execute External Programs" in Settings tab of Edit Script do?

jblomqvist — Thu, 13 Aug 2015 17:17:29 GMT

Hi all,

Can anyone tell me what does "Can Execute External Programs" in Settings tab do exactly?

The Reference Manual says "If this option is selected execute statements may be used in the script." but it is not exactly very clear what it means anyone got any examples?

Re: What does "Can Execute External Programs" in Settings tab of Edit Script do?

Qrishna — Thu, 13 Aug 2015 17:22:21 GMT

You run/execute some non-qlikview stuff like deleting external files ect.

EXECUTE CMD.EXE /C del "$(vQVDSourcePath)STATE.qvd"; - this command/script deletes an external file.

Hope that helps

Re: What does "Can Execute External Programs" in Settings tab of Edit Script do?

maxgro — Thu, 13 Aug 2015 17:24:50 GMT

from Qlik help

Can Execute External Programs

If this option is selected execute statements may be used in the script.

So, you can use the execute statement in the script (often to call dos batch, example if you want to delete some files from Qlik); what's the execute statement?

Always from help

With the Execute statement it is possible to run other programs during the re-execution of the QlikView script, e.g. conversions that are necessary.

The syntax is:

execute commandline

where:

commandline is a text that can be interpreted by the operating system as a command line.

Examples:

Execute C:\Program Files\Office12\Excel.exe;

Execute winword macro.doc;

Execute cmd.exe /C C:\BatFiles\Log.bat

Note!
The /C needs to be included as it is a parameter to cmd.exe.

Re: What does "Can Execute External Programs" in Settings tab of Edit Script do?

Thu, 13 Aug 2015 17:31:49 GMT

John, the main purpose is to execute the external scripts withe "EXECUTE" like .bat files etc.

Please go to help file to find out more