Re: [Virtuoso-users] Upgrading virtuoso....

2012-05-01 Thread Alex
Hello, as always I would be grateful if someone could help me with the following questions.. 1) While in isql I cannot display previous commands in history. The up key button shows the famous ^[[A string. This happens only in isql. In the terminal I can see the previous commands using the referre

Re: [Virtuoso-users] Handling large file sizes in variables

2012-05-01 Thread Mitko Iliev
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 t

[Virtuoso-users] Handling large file sizes in variables

2012-05-01 Thread Quentin
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 truncat