[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Range Question
- Subject: Range Question
- From: "Calder, Chris" <CCalder@JUSTICE.GC.CA>
- Date: Wed, 19 Jul 2000 14:22:46 -0400
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