I think I found the issue in the structSort.java source. The double
value is being converted to a int and thus truncating a longer
number . I really think this should be converted to a long.
public int compareTo(numericSortElement o) {
double otherVal = o.value;
int result = new Double(value).compareTo(new Double(otherVal));
if (asc) {
return result;
} else {
return -1 * result;
}
}
Thanks,
Charlie
On Mar 14, 10:43 am, Skellington <[email protected]> wrote:
> Hello,
> I've been using the sortstruct function and it's been working great,
> up until recently. I'm using the sort type "numeric". My first
> question is how long of a number does the "numeric" value sort on? Is
> it a int or a long, unsigned etc.?
> My issue is, I can have a value which is 20 digits long and it does
> not appear that it's sorting properly on my longer numbers. This leads
> me to believe that the "numeric" is most likely a unsigned int not a
> long. If this is the case can I please get a "numericLong" sort
> descriptor?
>
> Thanks,
> Charlie
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en