>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: