Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using a FOR LOOP with reccount()
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00134627
Message ID:
00134686
Vues:
15
>Is this being performed on a cursor by chance? If so, reccount() may not return the correct value unless you use the NOFILTER parameter in your query. However I would also reccomend using Scan/Endscan instead of the For/Skip as John has suggested.
>
>>The reccount() is not working.
>>Here is my code:
>>
>>i=1
>>for i=1 to reccount()
>> replace myfld with i
>> if !eof()
>> skip
>> endif
>>endfor
>>
>>What I want to do is change the value of myfld in all the records in the table. This FOR LOOP will not do that.
>>any ideas?

If you're trying to fill the myfld field with the record number, you could simply do:

Replace All myfld With RecNo()

HTH
_________________________________
There are 2 types of people in the world:
    Those who need closure
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform