Sort Command in 3.5 is adding lines to a variable

[Paul Looney]

Richard,
It has been a while...
I went back and checked my records. The problem (probably related to  
the number of characters per line) was thousands of NULL characters  
in the variable. When I removed the NULLs, everything worked fine.
So now I always trap for NULLs before doing a sort - and have not had  
a repeat of this problem.
By the way, we are not sure where the NULLS came from. Our best guess  
is that it has something to do with pasting text from a word  
processor into one of our notes fields.

I, too, would like to know the new limit. Mark?
Paul Looney

On Jul 2, 2009, at 12:52 PM, Richard Gaskin wrote:

> Paul Looney wrote:
>> I have had the opposite happen.
>> On a large variable, sorting removed lines.
>> Rev 3.0, OS X 10.5
>
> If memory serves, that was the result of a limitation of the sort  
> command where it could only be used reliably on data in which no  
> single line exceeded 65,535 chars.
>
> According to the v3.5 Engine Change Log, that was fixed in v3.5:
> <http://quality.runrev.com/qacenter/show_bug.cgi?id=5932>
>
> Unfortunately the current limit is not noted in the docs for the  
> Sort command, nor in that report, so I don't know exactly what it  
> is in the latest version.  But 64k of text was a lot for a single  
> line, so whatever it's been raised to should be plenty for most  
> common tasks.
>
>
> Timothy's report of the trailing blank line may be a regression  
> error which had been marked as "fixed" in the 3.5 Engine Change Log:
> <http://quality.runrev.com/qacenter/show_bug.cgi?id=7809>
>
> --
>  Richard Gaskin
>  Fourth World
>  Revolution training and consulting: http://www.fourthworld.com
>  Webzine for Rev developers: http://www.revjournal.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution