>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?
I would never trust Recno() as a value. There is a primary key for this and every table you create? Use it.
Recno() is a not a constant when you consider offline usage. The primary key is fixed and should never change. All it takes is one pack/reindex to blow away your recno() integrety.
__Stephen