Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATE freezes
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00457659
Message ID:
00458665
Views:
18
Andrew,

I have not seen a freeze like this that is related to *code* but I have seen instances of a freeze when there is a corrupt index that FoxPro is using to do the search on. Is the LOCATE optimizable such that it is using an index? If so, try reindexing. Corrupt indexes seem to be the one area that do not always get caught by the error trapper ie. instead of an error being triggered, the machine just hangs.

If that is not it, how about posting the code and maybe there is something going on that is not obvious to you with your loop construct.

Albert


>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform