[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
EVALUATE - meaning of BREAK
- Subject: EVALUATE - meaning of BREAK
- From: Joe Johnson <jejohn1216@SURFREE.COM>
- Date: Thu, 18 Nov 1999 07:45:17 -0800
Hi, group.
Does the BREAK command that follows each EVALUATE statement mean STOP?
I have an SQR which has this:
----------------------------------------------
evaluate #iteration
when = 1
put &a.bill_to_cust_id &a.bill_type_id &amount into store_sales(#i) cust_id prod_type month1_amt
let #i = #i + 1
BREAK
let #j = 0
while 1=1
get $cust_id $prod_type from store_sales(#j) cust_id prod_type
if $cust_id = &a.bill_to_cust_id and $prod_type = &a.bill_type_id
put &amount into Store_sales(#j) month2_amt
BREAK
end-if
let #j = #j+1
if #J > #I
put &a.bill_to_cust_id &a.bill_type_id &amount into store_sales(#j) cust_id prod_type month2_amt
let #i = #j
let #j = 0
BREAK
end-if
end-while
BREAK
when = 2
(etc..........)
-----------------------------------------------
I would think that the first BREAK in this section should have meant STOP, in which case is the code following it even being run?!?
Any clarification of this would be greatly appreciated!
TIA
Joe Johnson ;{)
__________________________________________
$14.95 a month Unlimited Internet Access.
Get your first month for $1.00.
http://www.surfree.com/promo