> SCAN > SELECT Invoice > LOCATE FOR in_code = lnCustCode > DO WHILE FOUND() > do some code > CONTINUE > ENDDO > SELECT sometable > ENDSCAN >>
SELECT Invoice SET ORDER TO InCodeTagName SELECT sometable SCAN SELECT Invoice SEEK lnCustCode SCAN WHILE In_Code = m.lnCustCode do some code SELECT Invoice && Not neccessary but I prefere to put it ENDSCAN SELECT sometable ENDSCAN