>>I just found out one may not index a table buffered View. I need to be able to reoder data currently in a view without having to requery the back-end because the user may have made 1 or 2 changes but what to view records in a different order before taking the next action.
>>
>>SET ORDER TO needs the views to have been indexed first. Buffered tables may not be index.
>>
>>Any ideas how to get round this?
>>
>>Thanks
>>
>>Mathias
>
>Could you SELECT .. ORDER BY the data from the view into a temporary cursor. Then use this to display the records to the user in whatever order. Revert back to the buffered view when you actually need to update.


Thank you.

Mathias