>hi,
>Whats wrong here ??
>
>

>create cursor foo (f1 N(2),f2 c(2))
>insert into foo values(2,"AA")
>insert into foo values(3,"BB")
>insert into foo values(2,"AA")
>insert into foo values(3,"BB")
>insert into foo values(2,"AA")
>insert into foo values(3,"BB")
>insert into foo values(2,"AA")
>
>Average f1 next 2 for f2 = "BB" to m.myvar
>
>?m.myvar && this returns 0
>

>
>any thing wrong ???
>
>how to put this right ??
>
>suhashegde

Before performing the AVERAGE position your record pointer to where you want to start the function from becaase you are using "NEXT 2" and after the INSERT's you are at the last record.