We have a multi-valued field that is being exploded for a sort. The dictionary item calls a program to convert the value. When we were on D3, this worked correctly. When we moved to Jbase, the sort failed. It seems to only sort on the first multi-value of each record selected. The program call was originally in <8> of the dict item. Another developer moved it to <7> after the issue was discovered. That worked fine for a while as the order of the original format sorted very close to the sort of the updated format. However, additional changes have been made that now make it obviously incorrect.
<8> is the proper location for this call. The subroutine being called does use a few ACCESS references. At first I thought it might be something there, but it does do the conversion correctly. So the outputted data is correct with its format, but the sort result is wrong. Stumped.
------------------------------
Chris Razzano
Senior PICK programmer
Houston's Inc
------------------------------