>did u mean if i just use the sql like this:
>"select * from table where recno() >= 10 and recno() <=20 into cursor temp_cursor"
>will also comes up wrong result?

No, that will work fine. You just can't specify an alias in the RECNO('table') function, or if your SQL involves more than one table then even the RECNO() won't work. As you've specified will work fine.