>>I have a DO loop that does a LOCATE. If a record matches the LOCATE scope an operation is performed. The program then does a SKIP 1 and does the LOCATE again.
>>
>>This loop works for about 40-70 iterations, then will just freeze. A check of NT Task Manager shows VFP as "not responding". It is as though VFP just ran out of memory.
>>
>>The total table has about 80,000 records and is 7.1 MB in size.
>>
>>Has anyone run across this? Is there a workaraound?
>>
>>I am using VFP6 SP4 on NT 4.0 SP6.
>>
>>Many thanks.
>
>Andrew,
>Locate and skip doesn't sound to be the right combination (of course depends on code). Might it be that your code causing an endless loop ? It would help if we could see some code :)
>Cetin
I need SKIP in this instance because I start from the LOCATEd record and then use the data in the record to do a LOCATE on a second table. SKIP on the first record ensures that LOCATE...REST looks only at the remainder of my first table.
I cannot index either. This table is updated by a separate application that updates the table through ODBC.
I found the probelm. It was a corrupt index in a DIFFERENCT table (that is indexed).
Regards.