How to find the size of the File in Navision

Hi G. Madhan,

If I understand you correctly - are you asking what the maximum file size that can be store in Nav. If so and assuming you are storing as a blob.

From the help:

BLOB
A BLOB (Binary Large Object) is a complex data type. Variables of this data type differ from normal numeric and string variables in that BLOBs have a variable length.

The maximum size of a BLOB is normally determined by your system's disk storage capacity. However, the maximum size in C/SIDE is 2GB.

Another solution is to store a link to the document in the record link table and hyperlink to it to view.

Hope this helps.

Getting the size of a file isn't too difficult :

    PROCEDURE GetFileSize@1000000000(FileName@1000000000 : Text[1024]) FileSize : Integer;
    VAR
      InFile@1000000001 : File;
    BEGIN
      InFile.OPEN(FileName) ;
      FileSize := InFile.LEN ;
      InFile.CLOSE ;
    END;

Thank You very much to you all.

Actually I wanted to make my code More efficient. So I did this post.

The code which I had written was...

FileG.RESET;
FileG.SETRANGE(Path,FlPath);
FileG.SETRANGE("Is a file",TRUE);
FileG.SETFILTER(Name,'%1','*.*');
IF FileG.FINDFIRST THEN BEGIN
REPEAT
IF FileG.Name = FlName THEN
"File Size" := FileG.Size;
UNTIL FileG.NEXT = 0;
END;

Using it I was able to satisfy my requirement..
But the code which you wrote works very well and also very efficient...

Thanks a Lot.