Problem with SORTn command
Boaz Bezborodko
boaz at mirrotek.com
Thu Apr 23 14:23:51 PDT 2009
> Please review this and let me know if I am using SORTn properly.
>
> Using version 5.6.6 I have 7 sort levels on the report and I specify
> SORT2 in sort/selection processing to be equal to a dummy variable.
> IOW, it's supposed to replace the second sort option.
>
> On everything but SORT2 the sorts are laid out properly. I have set up
> the processing table to hit SORT2=bh both on each record and only the on
> the first record with no difference. It hits this before bh is set in
> the processing table and bh is set just before processing the SELECT
> command.
>
> I've tried with bh set as (1,*) or the same as the original place
> setting of (2,*). I also tried SORT2(2,*)=bh and SORT2(1,*), but
> nothing changes.
>
> I have stepped through the process with the debugger and bh is set
> properly, (bh can be set to a value from "1" to "4") but the results
> don't change. The report displays the results as if the SORT2 command
> is never considered.
>
>
> What am I doing wrong?
I found out what I was doing wrong. I was setting SORT2=bh before
setting bh. Once I moved it to a point after bh is set then it works.
The filePro manual doesn't make it clear that this is a requirement.
(The filePro manual also doesn't make clear that @WBRKn occurs in
reverse order to the sort order.)
Boaz
More information about the Filepro-list
mailing list