>Hi,
>but the record no. is not equal to the row no. I want to display row 1,2,3,4,5,6....
>the record no. may be, 2, 4, 10,1,8....
>
>Derek
Right, I understand and I didn't suggest to use recno(). I suggested to add number in the underlying cursor. One of the ways would be to do it after the fact, e.g.
select fields, cast(0 as int) as RowNumber from myTable into cursor curGrid readwrite
replace RowNumber with recno() in curGrid all && this will add 1,2,3, etc. numbers to the cursor
If it's not broken, fix it until it is.
My Blog