Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

9 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     This may be because of the security settings.

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

Celambarasan

Not applicable
Author

Hi,

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

Thanks,

-Khaled

Not applicable
Author

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.

CELAMBARASAN
Partner - Champion
Partner - Champion

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
Author

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
Author

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

Not applicable
Author

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
Author

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
Creator III
Creator III

‌anyone where is this setting in Qlik sense