Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Using EXECUTE statement.?

Hi,

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

Execute_Error.png

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

I see nothing wrong with the syntax. Kindly suggest.

Regards,

-Khaled

1 Solution

Accepted Solutions
Not applicable

Using EXECUTE statement.?

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

9 Replies

Using EXECUTE statement.?

Hi,

     This may be because of the security settings.

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

Celambarasan

Not applicable

Using EXECUTE statement.?

Hi,

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

Thanks,

-Khaled

Not applicable

Using EXECUTE statement.?

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.?

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

Not applicable

Using EXECUTE statement.?

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

Not applicable

Using EXECUTE statement.?

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

Not applicable

Using EXECUTE statement.?

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

Not applicable

Using EXECUTE statement.?

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.

mangalsk
Contributor III

Re: Using EXECUTE statement.?

‌anyone where is this setting in Qlik sense