>Hi fox world!!!
>I'm using a select statement...
> into cursor MyCursor
>i want to do a for loop on the values , but i always get the same value...
>there is sample of that code
>select usag_iden ;
> from usagers4 ;
> where !deleted() and ;
> left(usag_iden,3) = tcProj_code and ;
> Grou_code = tcGrou_code ;
> into cursor NextMembre
>....
> for i = 1 to _tally
> letMemb=substr(usag_iden,5)
>....
>The (usag_iden) always gives me the same value...
>How do i get next one?
Rather than a FOR...NEXT loop, use SCAN, which iterates through the records of the cursor. The FOR...NEXT loop never moves the record pointer unless you explicitly tell it to do so.