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


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

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.


This does not mean I don´t see the logic for the required behaviour, but as I see it there is not much to gain with this feature, except for a more logic and robust design of Visual FoxPro. And we both know that there are dozens other (design) issues that need to be addressed that In my opinion are more important than this one. I really want the VFPT to deliver a version with as less bugs as possible. I think you would agree with this.

Walter,


Completely.

Fabio