M
marian.edu
Guest
normally you could but apparently it doesn’t really work, or I just expect it to behave differently 
OPEN QUERY q FOR EACH customer, FIRST order OUTER-JOIN OF customer WHERE order.custnum = ?. DEF VAR icnt AS INTEGER. DO WHILE TRUE: GET NEXT q NO-LOCK. IF NOT AVAILABLE(customer) THEN LEAVE. /* did expect that to be filtered already, customers with no orders here */ IF order.custnum = ? THEN icnt = icnt + 1. END. MESSAGE icnt VIEW-AS ALERT-BOX. Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212
Continue reading...
OPEN QUERY q FOR EACH customer, FIRST order OUTER-JOIN OF customer WHERE order.custnum = ?. DEF VAR icnt AS INTEGER. DO WHILE TRUE: GET NEXT q NO-LOCK. IF NOT AVAILABLE(customer) THEN LEAVE. /* did expect that to be filtered already, customers with no orders here */ IF order.custnum = ? THEN icnt = icnt + 1. END. MESSAGE icnt VIEW-AS ALERT-BOX. Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212Continue reading...