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

Re: Evaluate .. When with multiple conditions



Cliff,
    You could always do the following.  May be a little slower processing
but I think it would cover your condition better.   I am pretty new to SQR
and do not know if a between statement would work in an evaluate statement,
looked for some examples but couldn't find any, so probably not.
Tom Hins
Information Technology - Application Solutions
University of Oklahoma Health Sciences Center
P.O. Box 26901
Oklahoma City, OK  73190
Phone:(405) 271-2262 Ext. 50213
Fax: (405) 271-2352



Evaluate $Cov_End_Dt
        when >= $CurrDt-90
              if $cov_end_dt < $CurrDT
                        do date-meets-criteria
                  else
                        show 'date must be in future '
                end-if
        when-other
               do something else
end-evaluate


-----Original Message-----
From: ANDERSD2 [mailto:ANDERSD2@OAKWOOD.ORG]
Sent: Monday, June 11, 2001 9:59 AM
To: SQR-USERS@list.iex.net
Subject: Re: Evaluate .. When with multiple conditions


Evaluate $Cov_End_Dt
        when >= $CurrDt-90
                do Something
        when <= $CurrDt
                do Something else
        when-other
                show 'uh-oh'
end-evaluate

I do not believe you can utilize the AND statement within a WHEN of an
EVALUATE

-----Original Message-----
From: Cliff Scott [mailto:SCOTTC@SENSORMATIC.COM]
Sent: Monday, June 11, 2001 10:45 AM
To: SQR-USERS@list.iex.net
Subject: Evaluate .. When with multiple conditions


I can't get this to work.  I get a missing quote error message.  Is it
because you can't have multiple conditions in a when?  If I take out the
second condition, I don't get an error.

Evaluate Cov_End_DT
  When >= $CurrDt-90 and <= $CurrDt
  When other
     Show 'found other'
End-Evaluate