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!