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?
kenweber
GCom2 Solutions
Microsoft Certified Professional