EXISTS not working as expected

doddwell

Hello
I have a text variable containing the UNC path to a file and that I pass to the HYPERLINK function and this opens the file as expected. I want to alter the code so that it first checks that the file exists before attempting to open it. To do this, I pass the same text variable to the EXISTS function but this does not find the file. Any suggestions? Thanks. Sample code below.

UNCPath := '\\servername\sharename\filename.tif';
IF EXISTS(UNCPath) THEN
HYPERLINK(UNCPath)
ELSE
ERROR('Cant find file');


Many Thanks

Kishorm

Use the FileMgt.ClientFileExists() function instead in CU 419 "File Management" - this works with UNC paths.

And if you are using an earlier version of NAV which doesn't have this function then you can add it in...

PROCEDURE ClientFileExists@14(FilePath@1001 : Text) : Boolean;
VAR
  ClientFileHelper@1012 : DotNet "'mscorlib'.System.IO.File" RUNONCLIENT;
BEGIN
  EXIT(ClientFileHelper.Exists(FilePath));
END;

Kishorm

Use the FileMgt.ClientFileExists() function instead in CU 419 "File Management" - this works with UNC paths.

And if you are using an earlier version of NAV which doesn't have this function then you can add it in...

PROCEDURE ClientFileExists@14(FilePath@1001 : Text) : Boolean;
VAR
  ClientFileHelper@1012 : DotNet "'mscorlib'.System.IO.File" RUNONCLIENT;
BEGIN
  EXIT(ClientFileHelper.Exists(FilePath));
END;

archer89

Follow http://navnilesh.blogspot.co.at/2015/01/checking-if-directory-exists-microsoft.html?m=1

Kishorm

archer89 wrote: »

Follow http://navnilesh.blogspot.co.at/2015/01/checking-if-directory-exists-microsoft.html?m=1

That looks like it's checking to see if a directory exists, not a file. My original post above should work fine for a file on a UNC path.