>>I'm trying to set indexes on a view that is browsed in a grid, so that the user can change the order in which they see the data. I have it in the load of the form, and it steps through the code just fine, but the order of the view isn't changed. The session view doesn't show any order set or anything, like nothing has happened. I also repeated the indexing code after the Requery so that I wouldn't loose indexes, but with no luck. Any ideas?
>>Thanks,
>>Becky
>
>Could you post your code?

Well, the truth of the matter is that I just gave up on the indexing views. I created two separate view, each ordered differently. Then when the user clicks the radio button on screen to change order, I requery the newly requested view and stick it in the grid. This works fine. I don't know why the index didn't work. I had something like:
SELECT (thisform.cTable)
INDEX ON lastname+frstname+catcode+skilcode TAG nameorder
INDEX ON skilcode+catcode+lastname+frstname TAG skilorder (trims on the names)
SET ORDER TO nameorder

Thanks
Becky

Lucky me, I'm going to Dallas all next week for COBOL training, yuk!