>>>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
Mathais,
This is from memory, but if you make the buffering on your view Table Buffering you can actually INDEX ON and create tags for the file. Youcanthen turn buffering back to its original value and the tags will still be accesible by SET ORDER TO.
HTH
regards
Ian