Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using a FOR LOOP with reccount()
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00134627
Message ID:
00134686
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform