How to find out names of all files saved in a folder and error "The maximum length for a string ..."

carbon

Hi all,
is there some workaround? I use this C/AL:

RecLFile.SETRANGE(Path, MySearchigFolder);
RecLFile.SETRANGE(RecLFile."Is a file", TRUE);
IF RecLFile.FIND('-') THEN BEGIN
  //somethig what you want
UNTIL RecLFile.NEXT = 0;

This C/AL will works with no error if MySearchigFolder is not nested too deep. If MySearchigFolder is for instance "C:\ProgramData\Microsoft\Microsoft Dynamics NAV\60\Server\MicrosoftDynamicsNavServer\users\DOM\John.Parker\TEMP" (default value of TEMPORARYPATH) the error (The maximum length for a string value is 98.) will displayed because field Path in table File is declared as text 98.

Any idea how to get name of all files and not to use .NET (Automation)?

Juhl

You have to use .NET and why not???
.NET is power under your thumps

Juhl

https://juhl.blog/2017/07/05/get-filelist-using-net/

I wrote about it too

HannesHolst

Try this:

RecLFile.SETFILTER(Path, MySearchigFolder);
RecLFile.SETRANGE(RecLFile."Is a file", TRUE);
IF RecLFile.FIND('-') THEN BEGIN
  //somethig what you want
UNTIL RecLFile.NEXT = 0;

AK

Guys, did you read his posting? No .net and the path is longer than 98 characters.

https://forum.mibuso.com/discussion/29301/read-multiple-txt-files-from-a-directory

Juhl

Why not .net ?

EvR

Juhl wrote: »

Why not .net ?

Maybe because he wants his code to be future-proof (D365/extensions). But then again, when you're targetting D365 you wouldn't be talking about files and directories