>>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.
>
>Take a look at the CONTINUE option for LOCATE.
>
>A corrupt index may be at fault here. Try a REINDEX, or, if your table isn't intricately linked in a database, you could manually delete all your index tags, then recreate them.
The table is not indexed but you appear to be right -- the index was corrupt and the table needed to be reindexed.
Regards.