Hi Fabio,

>Walter, not misunderstood my words, is not one controversy but only a free exchange of ideas.

I know, and I appriciate that...

>Well, I don´t see the application that much in views (local, remote, cursor, ca), because you already have limit the resultset, and by default you´ll have no indexes available anyways. So if you want to sort the resultset on any column you´ll have to create an index or requery with the proper order. In that respect there is no difference between sorting on recno() or any other column.
>
>Attention, with TableBuffering:
>

>- set record buffering
>- index on recno()
>- set table buffering
>- insert records  <== negative recno()
>- tableupdate() <== this not update the index
>

>

I know, I did not mean an INDEX ON RECNO() specificly, Mikes´ solution might work well.

>The problem of tablebuffering can be easily circumvented when at the time the view is requeried you set the buffermode to 3, index and turn it back to 5 again.
>
>Yes, but i cannot have buffered updates open.
>
>

Neither you can when REQUERY()ing views, so this is the perfect time to do this.

Walter,