Re: Range Question

[Vishner@AOL.COM]

Hi Chris,

If $Deptid = '7530', the range will return true whether
$TORANGE = '7530' or '7531'

If $Deptid = '7530 ' (note the extra space), the range
will return true if $TORANGE =  '7531',
but will return false if $TORANGE =  '7530'

HTH,
Hugh


In a message dated Wed, 19 Jul 2000  2:24:38 PM Eastern Daylight Time, "Calder, 
Chris" <CCalder@JUSTICE.GC.CA> writes:

<< Hi Folks!

Ok, here's the scoop. The users enter a From and To range using the
Department Id.
When entering a Range of 7530 - 7530, no data is returned. If I use a range
of 7530-7531,
data is returned for department 7530. I suspect it is the code below using
the RANGE function.
I'm assuming that if $DEPT = 7530 and $FRRANGE and TORANGE are also 7530,
the value will
be returned as one (1), therefore true. Can anyone confirm this?

Thanks in advance! ;-)


  EVALUATE &L.LNG_RQMT_PSN
                WHEN = '1'
                     ADD 1 TO #DEPTALL1
                     IF RANGE($DEPT,$FRRANGE,$TORANGE)
                        ADD 1 TO #SECTOR1
                     END-IF
                     IF LTRIM(RTRIM(&LOC.GEOLOC_CODE,' '),' ') = '350614'
                        ADD 1 TO #NCR1
                     END-IF
                     BREAK

Chris Calder
Programmer/Analyst
PeopleSoft - HRMS
Tel: (613) 946-4751
 >>