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