>>>In my grid class I allow users to sort on up to 3 columns by clicking in the headers. I convert all the fields to characters in order to string them together. For example, the code might look something like:
>>>INDEX ON CharField1+STR(NumField2) TAG temp
>>>The problem is that if the numeric field contains negative numbers, they don't sort properly by value. How can I get the numbers to sort correctly and yet index on multiple fields?
>>>
>>>Thanks,
>>
>>Elyse,
>>
>>Try this:
INDEX ON CharField1 + BINTOC(NumField2) TAG temp
This will work, however, only if the numeric field has no decimal places.
>
>Thanks, but the numeric fields do have decimals.
OK, I think we got it this time. Use BINTOC() and multiply the field value by 10 ^
n, where
n equals the number of decimal places. The upper limit would be 9 decimal places (1 billion). Will this work?
George
Ubi caritas et amor, deus ibi est