Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LOCATE freezes
Message
 
To
29/12/2000 01:02:23
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00457659
Message ID:
00457690
Views:
29
>>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.
---------------------------------------
Magna Carta Software, Inc.
WEB: www.magnacartasoftware.com
Support: support@magnacartasoftware.com
Sales: sales@magnacartasoftware.com
FAX: +1 (972) 377-9074
7000 Independence Pkwy., Ste. 160-227
Plano, TX 75025, USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform