>Right, but the problem is that the program is build on a class that needs table buffering to work well. From the moment i change the buffering status this thing starts to act strange. (even when i change it before the index an reset it afther the index)
I uses Table buffering with emptying buffer/RecordBuffer/IndexOn/Tablebuffer change,
and until now i have not found critical issues.
Of course, if you want a change of order with table buffer not empty,
you have to work very more.
>
>So i have only 2 options : one is to find a sollution to change or create an order not using index on hoping the problem will be solved or te rewrite the hole class...
>
RV don't support literal parameters, like:
SELECT * FROM db!sometable ORDER BY &?eOrder
a way can to be, to define the RV on the fly, at runtime.
>anyway thnx fabio