>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.