>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.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up