RE: Specifying Check for Range in ILE RPG ?

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

rpg400-l-request@midrange.com wrote:

>C                   If        Row >= RowStart and Row <= RowEnd
>C                             And Bin >= BinStart and Bin <= BinEnd
>C                             And Shelf >= ShelfStart and Shelf <= ShelfEnd
> *   Criteria met, do Something here.
>C                   EndIf

Note that this should often not work for the same reasons a similar date range 
comparison would often fail using YearYYYY, MonthMM and DayDD.

Another post mentioned 'consistency'. This is definitely important in the sense 
that the Bin, Row and Shelf designations must use a collating sequence that 
allows range testing to work at all. If, for example, the second character of 
the Bin identifier goes first 'A-F' then '1-9', but the third character's 
sequence is '1-9' then 'A-F', there's going to be a real issue.

If the identifiers are 'consistent', then simple concatenation ordered by 
significance should work just as it would with a date range. Otherwise, the 
only thing I can think of is to have a file keyed uniquely by Row/Bin/Shelf 
with at least one additional sequencing field. The range test would then be 
done on sequencing field values rather than on Row/Bin/Shelf directly.

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now! 
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at 
http://webmail.netscape.com/