Hi Sylvain,

The view can be indexed if it is in a Row buffering mode. If you want to index a table buffered view, all you need to do is to switch buffering to Row, index it and switch the buffering back to table mode.


>Hi everyone!
>
>I'm a little stuck on a problem and I'm looking for pointers here.
>
>I have a remote view (SQLServer backend), which is buffered at the VFP end since I am doing updates from this view. The data is displayed in a grid - so far so good.
>
>The order in which the data is displayed is important, since each record is a single action from a procedure, which has to be followed to the letter. So, I need to be able to change the order in which the records appear. I already have the code that takes care of the order in the table (ie my "Sequence" field is updated properly). If I save and Requery(), the records appear in the correct order.
>
>The problem is that I have to save and requery in order to show the records in the right order. If I could just have an index in my sequence field, everything would be great, but since we can't create an index on a buffered view... Suggestions?
>
>What I've done before is to have the updatable view and a non-buffered view. The non-buffered view is what is displayed, and I keep the two in sync all the time. What I don't like about that is that it's kind of a mess to code and more so to maintain, plus a little error in the code and you can easily end up showing one set of data but modifying another. In short, I'm looking for an alternative! :)
>
>Thanks in advance!