Hi Quentin,
You can just cast the return value from file_stat to integer e.g. :
var := cast (file_stat ('xx',1) as integer) ;
HTH,
Mitko
On May 1, 2012, at 10:03 AM, Quentin wrote:
> Hi,
>
> I'm attempting to manipulate a large file (4.4GB or so) in a procedure.
>
> As part of my processing the file, I'm maintaining a buffer and index. My
> problem comes in comparing my index to the filesize. file_stat(filePath, 1)
> returns the size as a varchar and atoi() over that gives me a truncated value
> (423557276). atof has precision problems, giving a value of
> 4718524416.000000 instead of 4718524572 which proves to be an issue.
>
> Are there any suggestions on ways to use file_stat on large files? It
> becomes an issue when I want to do something like
> while(bufferIndex<=fileSize)...
>
> --
> Quentin | Clear Blue Water Pty Ltd
> [email protected]
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats.
> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
--
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware
