topic Using EXECUTE statement.? in QlikView

Using EXECUTE statement.?

Wed, 22 Feb 2012 08:45:08 GMT

Hi,

When using Execute statement/keyword to run a file upon reload, I get the following error:

1. Execute C:\audio.mp3
2. Execute D:\Sampletext.doc;

I see nothing wrong with the syntax. Kindly suggest.

Regards,

-Khaled

Using EXECUTE statement.?

CELAMBARASAN — Wed, 22 Feb 2012 09:12:28 GMT

Hi,

This may be because of the security settings.

Check with the security settings and set it as Allow System access.

Celambarasan

Using EXECUTE statement.?

Wed, 22 Feb 2012 09:21:28 GMT

Hi,

Marking the check box Script(Allow Database Write and Execute Statements) found under User Preferences>Security worked.

Thanks,

-Khaled

Using EXECUTE statement.?

Wed, 22 Feb 2012 09:30:48 GMT

Hi,

Although that works, I still cannot open anything that's not an application.

For example, the first and the second statements do not work while the third works.

1. EXECUTE C:\Users\Developer\Downloads\playbook_white1.jpg;

2. EXECUTE C:\Users\Developer\Desktop\Ex_EXECUTE\123.txt;

3. EXECUTE C:\Program Files (x86)\Internet Explorer\iexplore.exe;

Kindly suggest.

Regards,

-Khaled.

Using EXECUTE statement.?

CELAMBARASAN — Wed, 22 Feb 2012 09:38:49 GMT

Hi,

You need to open the image in windows picture viewer?

if so try with this

EXECUTE rundll32.exe shimgvw.dll,ImageView_Fullscreen C:\Users\Developer\Downloads\playbook_white1.jpg;

Hope it helps

Celambarasan

Using EXECUTE statement.?

Wed, 22 Feb 2012 10:58:21 GMT

This will open a specific .txt file with notepad - the execute format is program (space) file

EXECUTE C:\WINDOWS\system32\notepad.exe C:\Documents and Settings\ep1285\Desktop\test2.txt;

Regards,

Gordon

Using EXECUTE statement.?

Wed, 22 Feb 2012 11:00:11 GMT

...forgot to add that the script will pause until the file is closed - is this what you want to do?

Using EXECUTE statement.?

Wed, 22 Feb 2012 13:48:01 GMT

Hi,

Thanks, Yes, I wanted to open the image in some photo viewer..

Although, the script execution dialog display 'Execute.......jpg done',it does not open the image. I have verified the paths for both the photo viewer and image.

Regards,

-Khaled

Using EXECUTE statement.?

Wed, 22 Feb 2012 13:51:26 GMT

Hi Gordon,

Thanks. Yes, wanted to ask that already...

Just wanted to open an app using execute and the script should automatically continue/complete execution. Instead, it pauses script execution until the file/app is closed. I guess there must be a work around.

Regards,

-Khaled.

Re: Using EXECUTE statement.?

mangalsk — Mon, 18 Jun 2018 09:10:34 GMT

‌anyone where is this setting in Qlik sense