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
>index on file_name to file_name
>dir *.idx
>use
>dir *.idx
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.
>>
>>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05