For this problem I've always ended up doing an index on command to create a temporary index on the view after the original data has been pulled. I think one advantage to this solution is you don't have to requery the view to change the order. One problem is that you need to write the temp index to a local drive to avoid potential multi-user conflicts over the index.

g

>Hi all,
>
>i have some views in my database with table buffering on them. The records of these views are displayed in a grid with no order. Now i want to requery them with an order free to chose by the user.
>
>I wonder if its possible change the 'query code' behind the view to the chosen order and to requery the view.
>
>thnx.