>I want to use a drop-down box to change the order of items in a view displayed in a grid on a form, but there is no index file for the view and I am not sure how to create one.
>
>I don't see a way to put a parameter in the order by section of the views sql statement.
>
>Is it possible to dynamically do this? If so, how?
You can index a view the same way as you index a table:
Select View1
Index on field1 tag tag1
Index on field2 tag tag2
It will work for Buffering=3 only, i.e. if you have Buffering=5, then use CURSORSETPROP() to reset it temporarily.
Edward Pikman
Independent Consultant