Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
LOCATE freezes
Message
 
À
29/12/2000 01:02:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00457659
Message ID:
00457690
Vues:
30
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform