[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
- Subject: Re: Evaluate .. When with multiple conditions
- From: "Thomas D. Hins" <Thomas-Hins@OUHSC.EDU>
- Date: Mon, 11 Jun 2001 10:42:29 -0500
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