[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Range Question



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