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!
Sylvain Demers