Hi All,
Getting this funky error in method movenext. This script runs through SOs and deletes the ones in a particular range for a particular customer. This is the snippet in question. Any idea what I might have goofed? it seems to work sometimes, and then not others.
Do While not(cBool(oSO.nEof))
sOrderNo = ""
sCustNo = ""
retval = oSO.nGetValue("SalesOrderNo$", sOrderNo)
retval = oSO.nGetValue("CustomerNo$", sCustNo)
if ucase(sCustNo) = ucase(sCustToDelete) and sOrderNo >= sStartingOrder and sOrderNo <= sEndingOrder then 'delete order if we have a match
retval = oSO.nDelete()
end if
retval = oSO.nMoveNext() '**********ERROR IS HERE*************
Loop