Hyperlink - Open Application and File

[melven]

Hi,

I would like to open a .JPG file in a specific application. The .JPG path is saved in an SQL database {table.imagepath}. And the application I would like to use is QuickTime PictureViewer because there are no editing features. I would like to select PictureViewer with CR because the default program can be changed by users on individual computers.

Using a hyperlink and adding {table.imagepath} to the formula editor I can open .JPGs in the default .JPG application.

And using a hyperlink and adding "C:\Program Files\Quicktime\Pictureviewer.exe" to the formula editor I can open QuickTime PictureViewer.

But I do not know the correct format to use to open .JPG {table.imagepath} in "C:\Program Files\Quicktime\Pictureviewer.exe"

Any help would be appreciated.

Thank you,
Mel

CR Developer V 12.2, .NET

 

[melven]

I am getting closer. In hyperlink formula editor:

"C:\Program Files\Quicktime\Pictureviewer.exe ""I:\Images\Image.jpg"""

This will open Pictureviewer and the .JPG, but I have not been able to get the database {table.imagepath} field to open a JPG yet.

"C:\Program Files\Quicktime\Pictureviewer.exe ""{table.imagepath}"""

does not work.

Mel

CR Developer V 12.2, .NET

 

[fisheromacse]

maybe:
"C:\Program Files\Quicktime\Pictureviewer.exe "{table.imagepath}

 

[melven]

Thanks for the reply fisheromacse,

"C:\Program Files\Quicktime\Pictureviewer.exe "{table.imagepath}""

does not recognize anything after the 2nd quotation as formula without the double quotes. And double quotes the way I have it makes {table.imagepath} text rather than table and field.

Have tried with {table.imagepath} outside the quotes also with no luck using + or &.

"C:\Program Files\Quicktime\Pictureviewer.exe "+{table.imagepath}

Also tried +{table.imagepath}+ inside the quotes to try reverting back to table and image with no luck.

Mel

CR Developer V 12.2, .NET

 

[melven]

I have the answer, is a bit wacked though.

"C:\Program Files\QuickTime\PictureViewer.exe """""""""""+{IMAGES.IMAGE}+""""""""""""

Tried using double quotes like the text path above but would only recognize table.field with odd number of quotes because it is watching the opening single quote. For that reason, double surrounded by triple quote does not work. So had to skip double and got to triple surrounded by quad quote for odd number. I am sure there is a better explanation for this, but it works.

Mel

CR Developer V 12.2, .NET