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

carbon · 2017-08-07

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 · 2017-08-07

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

Juhl · 2017-08-07

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

I wrote about it too

HannesHolst · 2017-08-07

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 · 2017-08-09

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 · 2017-08-09

Why not .net ?

EvR · 2017-08-09

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

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

Answers

Categories