Damned if I know, Andrew. Honestly, I rarely index on a view or cursor and never more than one key if I do....I'm treating this as a philosophical discussion :-)

>Yep - I read your code too quickly - INDEX ON is good.
>
>BTW, it looks as if the idx file is deleted as soon as it is no longer the master index:
>

select * from sub_messages into cursor cuSM NOFILTER
>index on sub_id to sub_id
>dir *.idx  && shows sub_id.idx
>index on file_name to file_name
>dir *.idx  && shows file_name.idx
>use
>dir *.idx  && shows (none)

How do use this for multiple orders (eg for setting the order in a grid on a header click)?
>
>Cheers,
>
>Andrew
>
>

---

>
>>Hey Andrew,
>>
>>I was indexing to an IDX file, not a CDX tag. Indexing to an IDX always works.
>>
>>