Do you have an index on the table being SCANned? If you have an index
on the HOLD column you will get results you might not expect...

>>I don't understand what you are trying to do. Could you explain?
>
>I'm searching the table for invoices that have one line item on the invoice. If it does then I'm checking to see if that line item is category "CON" if it is I want to place that order on hold by placing .T. in the hold field of the invoice file.
>
>>
>>>My Scan is skipping records. I have add skip -1 as the last line of the IF() statement. This has correct the problem but I don't think it is the correct solution.
>>>
>>>Scan while !eof() for lines=1
>>>lcCusnum=cuskey
>>>lnOrdernum=orderno
>>>lcCatkey=catkey
>>>If lcCatkey="CON" and orderfl.orderno=lnOrdernum
>>>Replace hold with .T. while invfl.orderno=lnOrdernum
>>>Wait window;
>>>"Replaced Hold with True as Requested for Customer # "+lcCusnum;
>>>at 15,115 timeout 0.75
>>>Skip -1
>>>Endif
>>>Endscan
>>>
>>>TIA